Gentlefolk,
I am having some difficulty understanding how the various insert/delete/update mechanisms work on a TSQLQuery
I have read a lot of forum entries and the tutorials but I am struggling....
An SQL 'select' is OK, set the SQL string, set the parameter/s and set the SQLQuery active. Data from the database is in the SQLQuery.
The SQLQuery has a DeleteString, UpdateString and a InsertString. SQLQuery has an 'Insert' procedure and a 'Delete' procedure which from experimenting appear to execute the SQL statement in the related InsertSQL or DeleteString.
There is no 'Update' procedure.
Examples I have seen load an 'Update' SQL string into the 'SQLString' and and execute a 'ExecSQL' to perfor the SQL statement.
What have I missed? How does an update occur in the SQLQuery? How can perform one without loading the SQLString and ExecSQL, etc.
Any help appreciated, Ian.