If you leave the filter wide open, all the
records are available. In the simple recordset, you may use one column as a filter; in the previous examples
the filters would be something like Region = Eastern; On Tap = Yes; and Artist = Elvis
Costello. Finally, after you have defined a recordset, you can sort it by one field in either an ascending
or descending order.
To create a simple recordset, follow these steps:
1. From either the Bindings panel or the Server Behaviors panel, click the Add (+) button and
choose Recordset (Query) from the drop-down list.
2. In the Recordset dialog box, enter an identifying label for your recordset in the Name field.
It??™s good practice to prefix your recordset name with rs??”as in rsDBA. This prefix quickly
identifies the recordset in the code.
3. Select a connection from the Connection drop-down list.
4. If the desired connection has not been declared, click the Define button to open the Connections
dialog box. After a connection has been selected, the available tables are shown.
5. From the Tables drop-down list, select a table to work with. The chosen table??™s fields are displayed
in the Columns list.
6. By default, all the columns are included in the recordset. To specify certain columns, choose the
Selected option and then any desired field.
Pages:
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173