PgDAC

TCustomDADataSet.SQLUpdate Property

Used to specify a SQL statement that will be used when applying an update to a dataset.

Class

TCustomDADataSet

Syntax

property SQLUpdate: TStrings;

Remarks

Use the SQLUpdate property to specify a SQL statement that will be used when applying an update to a dataset. Statements can be parameterized queries. Names of the parameters should be the same as field names. The parameters prefixed with OLD_ allow to use current values of fields prior to the actual operation.

Use ReturnParam to return OUT parameters back to the dataset.

To create a SQLUpdate statement at design-time, use the query statement editor.

Example

UPDATE Orders
   set
      ShipName = :ShipName
   WHERE
      OrderID = :Old_OrderID 

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback