Writing Data Fields Back to PDMS

The following extends the ADO example of the previous section.

After executing a Table>Query Rows command (see the previous section), the right-hand pane displays the writeable fields on a white background, while the read only fields are displayed on a grey background.

1. Select a cell to edit by clicking inside it with the mouse cursor. The field editor box labelled Cell Text displays the field's value:

   

2. Type the new value into the editor and press the Update Cell button to copy the value back to the cell in the grid:

   

3. Continue to edit fields in this way as desired. The values have not been written back to PDMS yet. This happens when you close the connection, for example by selecting the PDMS> Close Connection menu option. This gives you the opportunity to accept or reject the changes:

   

4. If you click Yes the changes will be committed in PDMS. Clicking No aborts the changes. In either case the connection is subsequently closed.

   To see the code behind this example you can look at the ADOTest Visual Basic source provided in the samples directory.