Using the DeleteSQL, InsertSQL, ModifySQL, and RefreshSQL Properties
RefreshSQL properties to set the update SQL statements for each. These properties are all string list containers. Use the methods of string lists to enter SQL statement lines as items in these properties. Use an integer value as an index to reference a specific line within the property. The
RefreshSQL properties are accessible both at design time and at runtime.
with UpdateSQL1.DeleteSQL do begin Clear; Add(‘DELETE FROM Inventory I’); Add(‘WHERE (I.ItemNo = :OLD_ItemNo)’); end;
Below, the third line of a SQL statement is altered using an index of 2 with the
UpdateSQL1.ModifySQL := ‘WHERE ItemNo = :ItemNo’;