Creating a tabs application
This example covers the Tab application development. Other applications necessary to demonstrate its use are created.
Creating an Order Items form
1. Create a new multiple record form application based on the order_details table.
2. On the application menu click in SQL.
3. For the where condition add the following text: OrderID = [v_order]. The variable inside the square brackets is a global variable used to pass parameters between two forms .
4. On the application menu click in Select Fields.
5. Remove the OrderDetailsID field.
6. Click in Attribute Values.
7. On the Value in Database (Insert), select Auto increment (automatic) for the field OrdersDetailsID. A new order receive an automatically incremented field representing the orders ID ( OrdersDetailsID).
8. Generate the form source code by clicking in Generate Source from ScriptCase toolbar.
Creating an Order form
9. Create a new Simple form application based on the orders table.
10. On the application menu click in SQL.
11. For the where condition add the following text: OrderID = [v_order]. The variable inside the square brackets is a global variable used to pass parameters between two forms .
12. On the application menu click in Select Fields.
13. Select the fields OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, Freight and PriceOrder.
14. Generate the form source code by clicking in Generate Source from ScriptCase toolbar.
Creating an Tab application
15. Create a new Tab application.
16. Change the properties Table Width, Measure Unit, Tabs Alignment, Application Alignment and Exit, according to the table below..
17. Create folders to display in the application by clicking in Folder Settings.
18. For Label enter Order and click in Add.
19. Repeat the step above (18) to create the Details folder.
20. Click in Application Settings to link the applications to the created folders.
21. Select the Order folder and click in Add. Select the Orders form created previously and click in Next.
22. To the parameters to be pass select v_order to receive the v_order variable , created in the control application (filter). Pass the parameters according with the figure below and click in Save.
23. Select the Details folder in the Application settings and click in Add. Select the items form created previously and click in Next.
24. For passing parameters inform that v_order receives the v_order variable , created in the control application (filter). Pass the parameters according with the figure below and click in Save.
25. Generate the form source code by clicking in Generate Source from ScriptCase toolbar.
Creating a Control Application
26.Creating a new Control application.
27. Open the Fields folder and click in New Field.
28. Enter 1 for Quantity and click in Next..
29. Choose the Select type and enter Order for Name and Label.
30. Click in the Edition Lookup for the Order field and enter the instructions in the picture below for the SQL Select Statement.
31. Create the link between the Control and the created Tab application. Open the Links folder and click in New Link.
32. Clink in Create New Link. In the following display select the link Application type and click in Next.
33. Select the Tab application previously created and click in Next.
34. Enter the value of the Order field to the v_order variable . Click in Next.
35. Click in Save to complete the link and run the application.
|
|
|
 |
||
|
|
| Rate this Tutorial | |||||||
|
|||||||
|
