Database Guide
In Running a query, you ran the query before the window opened. Because
this query uses a host variable, you can't run the query before the
window opens, because the variable would be nil. To run a query with a
host variable, do the following:
- Because the query expects a department number as input, connect the
object attribute of the Department number text part to
the dept attribute of the query.
- Delete the currentRow part and the
aboutToOpenWidget-executeQuery connection.
- Add a new Find push button and connect its clicked
event to the executeQuery action of the multi-row query
part.
Your Composition Editor will look like this:

- Test your new visual part. Try typing the department number
20 and selecting the Find push button. Other
department numbers you can try are 10, 15, 38, 42, 51, 66, and
84.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]