Database Guide
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]