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. .Confirm that SIDemo is running in the Host Emulator, then open SIDemo.modelx in the Design Tool.
  4. In the Entity box, select CustomerPurchases and click the Recordset tab.
  5. Click the Test button to open the Test Recordset dialog box.
  6. From the Action box, select Select Record.
  7. Click the Edit button to open the Filter String Edit dialog box.
  8. In 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 appear as follows: CustomerList.Customer = "Q. ARMSTRONG"
  9. Click OK.
  10. Click Execute in the Test Recordset dialog box.

    If the select is successful, the record contents for Q. ARMSTRONG will appear on the terminal screen and the following message should appear:

    The selection operation reached an expected destination.

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 on the terminal screen and the following message should appear:

    The selection operation reached an expected destination.

Notes:



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