1 / 63

Database Updates Made Easy In WebFocus Using SQL And HTML Painter

Database Updates Made Easy In WebFocus Using SQL And HTML Painter. Sept 2011. Lender Processing Services. 1. Overview. What should you learn from this!. How to Use a Combination of. SQL HTML Painter WebFocus Dev Studio.

paniz
Download Presentation

Database Updates Made Easy In WebFocus Using SQL And HTML Painter

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Updates Made Easy In WebFocusUsing SQL And HTML Painter Sept 2011 Lender Processing Services 1

  2. Overview What should you learn from this! How to Use a Combination of SQL HTML Painter WebFocus Dev Studio To make your reports interactive and allow real time database updates Lender Processing Services

  3. Required Things you must have to make this work A database connection ID with update authority Ability to write WebFocus code in text editor Basic knowledge of SQL, HTML, Dev Studio Lender Processing Services

  4. Recommended Things I recommend to make this example work best Turn off page caching in WebFocus admin suite Force page headings to display on empty report Lender Processing Services

  5. Basic Dev Studio Report Lender Processing Services

  6. Basic Report Output Lender Processing Services

  7. Create Procedure for SQL Add Lender Processing Services

  8. Input SQL Code Lender Processing Services

  9. SQL - Edit Input Lender Processing Services

  10. SQL – Database Connect Lender Processing Services

  11. SQL – Insert Query Lender Processing Services

  12. SQL – Redirect Lender Processing Services

  13. Auto Prompt What you get if you run the SQL Procedure Lender Processing Services

  14. Create Work HTML Name it and make sure it is set not to show on users list Lender Processing Services

  15. Create an Empty Form Lender Processing Services

  16. Add Hyperlink to Form Submit Lender Processing Services

  17. Add Hyperlink Action Lender Processing Services

  18. Set Hyperlink Action Lender Processing Services

  19. Set Hyperlink Source Lender Processing Services

  20. Save Hyperlink Lender Processing Services

  21. Hyperlink Parameters Lender Processing Services

  22. Parameters Control Options Lender Processing Services

  23. A Blob of Page Elements Lender Processing Services

  24. Design The Page – Simple And Clean Arrange Fields Modify Headings Add Text to Buttons Other Visual Improvements Lender Processing Services

  25. Preview the Page Lender Processing Services

  26. Set Field Properties Lender Processing Services

  27. Tab Index You will want to set the tab index on every element to control the flow Lender Processing Services

  28. Remove Extra Tab Index from HTML Lender Processing Services

  29. Copy HTML To Clipboard Lender Processing Services

  30. Create Procedure to Hold HTML To be able to link to the html from the report we need to put the HTML in a procedure Hint: Make it easy to identify Lender Processing Services

  31. Insert HTML into Procedure Lender Processing Services

  32. Ready to Link To Your SQL and HTML are now ready to be linked to! Lets recap what you have done so far SQL code to add a record by receiving edited fields HTML form to allow user entry of fields Manual editing of HTML to adjust tab order Procedure to hold HTML that is linkable from a report Lender Processing Services

  33. Add Menu Link to Report Lender Processing Services

  34. Menu Link – Drill Down on Column Title Lender Processing Services

  35. Menu Link – Define Drill Down Lender Processing Services

  36. Menu Link – Set Drill Down Type Lender Processing Services

  37. Menu Link – Select HTML Procedure Lender Processing Services

  38. Menu Link – Set Target Frame Lender Processing Services

  39. Menu Link – Apply and Save Lender Processing Services

  40. Report Before and After Lender Processing Services

  41. Click Heading for Menu Lender Processing Services

  42. Add a Record Lender Processing Services

  43. Delete Example How does a delete differ from the Add No HTML Form No Editing User Fields Must Pass Record Key to SQL Lender Processing Services

  44. SQL – Delete Query Lender Processing Services

  45. Field Must Be In Report To Pass Lender Processing Services

  46. Does Not Have to Be Visible Lender Processing Services

  47. Order is Important Lender Processing Services

  48. Add Delete Option To Column Data Lender Processing Services

  49. Set Delete Parameters Lender Processing Services

  50. Pass the Hidden Field Lender Processing Services

More Related