How To Create Dynamic Forms In Desktop Application

1. Click on the abc.exe (Application) and the application will be open after this Press F12 Key.
2. After the pressing F12 key the window will open and you see the menu which name is Customize in this menu find the Manage Report Forms and click on it.
3. After this the new form will appear on your computer screen this is the form where we create a dynamic forms.
4. On this form you see the New Form button click on it and as soon as you click on the New Form button, it will generated a new row in the Existing Forms Section.
5. In this from you see the Report Title field click on it and enter the name of the form which will appear in your application.
6. In this from you see the Form Name field click on it and enter the name of the form which will be used at the backend of the application.
7. In this from you see the SQL field click on it and write the sql query for getting data from sql to form.
8. In this from you see the Report File field click on it and enter the name of the report which is linked with this form.
9. In this from you see the Name field click on it and enter the name of your text field and this name is used at backend.
10. In this from you see the Type field click on it and select the type of the field basically this is represent which type of data you want to getting from the database.
11. In this from you see the Text field click on it and enter the name of the field which is appear on the form.
12. In this from you see the Src field click on it and write the query for getting data from sql to this text field.
13. After this click on the Add button which will appear on the right side of the Src field.
14. As soon as you click on the Add button, it will generate a text field in the form.
15. After All these steps click on Update Form Button and the form will be generated.

How to generate a SQL query for Client Update of Dynamic Forms

1. Select the form from the Existing Forms section .
2. After this mark the checkbox of Export in Update Syntax which is available below the Existing Forms section.
3. And click on the Export SQL button, and as soon as you click on the Export SQL button it will generated a sql query for update.

TahaAli