Update Current Record

To update the current record in a recordset:

  1. Open Purchases.model 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 the Test button to open the Test Recordset dialog box.
  5. From the Action box, select Set Current Record Index .
  6. In the Set the current record index to box, type 2.
  7. Click Execute.
  8. 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.

  9. From the Action box, select Update Current Record and click Execute.

    Look in the Update current record box and notice that Select appears in the Field column and the Value column is blank.

  10. Type 1 in the Value column and click Execute.

    Notice that 1 now appears on line 3 of the Select column in the Terminal window.

Note: To test any scrolling operations that have been defined, click any of the available buttons in the Perform Scrolling Operation box. If there are no scrolling operations in the recordset, the buttons will be unavailable.