Detail tables in ISQL forms
Posted in 1993
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
Hi, I'm fairly new at using ISQL, so please bear with me if the answer to this question seems obvious. I'm creating a form which is similar to the "orders" form in the stores2 demo database. In the form I'm creating, however, I'd like to display all (or some subset which I can define/manipulate) of the detail rows associated with a given master row. As a concrete example, in the stores2 database, order number 1002 includes 2 items: 4 cases of footballs, and 3 cases of baseball bats. Using the "orders" forms, the user can only see one of these two items at a time and must use Next/Previous in order to see the other one. I want to create a form which displays all rows from the detail table (order_items) which are associated with the specified order number. Is this possible? I realize that it might take some work. Any help would be appreciated. BTW, we also have ESQL/C, so I code up some external routines if needed. Thanks Henry Ptasinski hptasins@is.internic.net