Saving the Values from Temp Table to database

By default, the values created in the Temp-table are not saved in the database. In order to save these values to the database for the future reference, you may create an event on a button. Following are the steps to accomplish the same.

• On the Screen Editor, drag and drop the Button widget from the Widget bar
• Once this button widget is selected, go to Events tab in the right panel
• In the tab Event, Create a new event record by clicking the New button
• In Widget give the widget name, here we gave the name of added Button
• In Event select the Choose event which fires on clicking the button and runs the specified procedure.
• Add a unique Sequence number
• Add a procedure name
• Write logic to write the values to database in the editor and save it with a ‘.p’ extension
• Save this ‘.p’ file name in Run
• In section Advanced Properties check All Values
• Save the above changes

Follow the below figure for representing the changes in Events tab