Please send your comments to: Raghavan
Your window must now have two datawindow controls. You will attach two datawindow objects to these controls - one a tabular datawindow with only selected items from the table, and the other a freeform datawindow that has all the columns from the table. The user must be able to scroll vertically and click on any row of the top datawindow control to display the corresponding detail row in the bottom datawindow control.
Overview:
Constuct a freefrom datawindow with a WHERE clause. Include script in the clicked event of the tabular (top) datawindow to find the row the user has clicked on (using GetClickedRow function), find the value of the item to be used in the WHERE clause (using GetItemX function), and use it to retrieve the second datawindow.
Construct a tabular and a freeform datawindow for any table (ITEM or PATIENT) would be appropriate in our hospital database.
The freeform datawindow should have a WHERE clause. You should do while designing this datawindow. Choose OBJECT,RETRIEVAL ARGUMENTS from the menu item of the SQL painter while designing the datawindow. Make sure that argument variable is of the right type (String ,Number etc.,).
Specify the appropriate WHERE clause.
Include a script in the first datawindow as suggested in the overview section.
Retrieval Argument provided but none expected
Please send your comments to: Raghavan
© Dr. Vijay V. Raghavan
BACK TO Table of contents
BACK TO DATABASE Main Page