RAD Studio VCL Reference
|
Specifies the SQL UPDATE statement to use when applying an update to a record and cached updates is enabled.
property ModifySQL: TStrings;
__property TStrings ModifySQL;
Set ModifySQL to the SQL UPDATE statement to use when applying an updated record to a dataset. Statements can be parameterized queries. To create a UPDATE statement at design time, use the UpdateSQL editor to create statements, such as:
UPDATE "Country.db"
SET Name = :Name, Capital = :Capital, Continent = :Continent
WHERE Name = :OLD_Name
At run time, an application can write a statement directly to this property to set or change the UPDATE statement.
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
What do you think about this topic? Send feedback!
|