There are several ways to run a database query. One way is to run
the query when your window opens:
Connect the window's aboutToOpenWidget event to the
multi-row query part's executeQuery action. This runs
the query and fills in the results just before the window opens.
Note:
If you have packeting enabled, use the openedWidget event to
trigger the query. The result table will be filled in just after the
window opens.
Now test your visual part by selecting
.
Play with this window to see how the query you have defined is run and how
its result table is displayed.
Try selecting a cell in a column that you selected for update and one that
is read-only. Notice how selecting a read-only cell is different from
selecting a cell for update.
When you select a row, the department number for the row appears in the
Department number field.
Experiment with scrolling through the rows with the vertical scroll bar
and scrolling through columns with the horizontal scroll bar.
Be sure to close the window when you are finished testing your
part.