Writing PDMS Data through SQL

SQL provides statements to update and delete data in a database as well as simply query it. For example:

UPDATE EQUIPMENT

SET AREA = 100

WHERE REFNO = '=12345/67'

and:

DELETE

FROM EQUIPMENT

WHERE REFNO = '=12345/67'

are fairly self explanatory.

You can also update data by editing the values in the output grid produced by retrieving data from the view or executing a SELECT Query. Position the text cursor by clicking on the item you wish to change, edit the value, then move the cursor off the row. SQL will update the data in the database.

Note:
If you are using SQL Server 2000 / MSDE, you need to make sure that the Microsoft Distributed Transaction Coordinator (DTC) is running before you can update data by editing the output grid. The DTC can by started up / stopped through the SQL Server Service Manager.
The SQL INSERT statement is not supported by PDMS Provider at this time, neither is inserting data by adding rows to the output grid.