Select Record

There are two possible ways to select a record: by condition or by index. The following procedures use SIDemo.modelx as an example.

To select a specific record by condition in a recordset

  1. Confirm that SIDemo is running in the Host Emulator, then open SIDemo.modelx in the Design Tool.
  2. On the Connection menu, click Connect to localhost via Telnet.
  3. In the Entity box, select CustomerPurchases and click the Recordset tab.
  4. Click Test to open the Test Recordset dialog box.
  5. From the Action box, select Select Record.
  6. Click Edit to open the Filter String Edit dialog box. Select Customer from the Recordset fields box, click the = button, and type the following in the Filter string box: "Q. ARMSTRONG"

    The filter string should look like this: CustomerList.Customer = "Q. ARMSTRONG"

  7. Click OK.
  8. Click Execute in the Test Recordset dialog box.

    If the select is successful, the record contents for Q. ARMSTRONG will appear in the test window result area.

Notes

To select a specific record by index in a recordset

  1. Follow the procedures described in Step 1 through Step 4 above.
  2. From the Action box, select Set Current Record Index.
  3. In the Set the current record index to box, type 3, and click Execute. To check that your current record index is set to the line number you want, view the indicator (for example, Current record index: <line number>) at the bottom of this dialog box.
  4. Select Select Record from the Action box and click Execute.

    If the select is successful, the record contents for Q. ARMSTRONG will appear in the test window result area.

Notes

 

Related Topics
Bullet How to add a recordset
Bullet How to test a recordset