When use SQLInsert, SQLDelete... From TVirtualQuery

[Eden0928]

Could you tell me about when use property: SQLInsert, SQLDelete, SQLUpdate from TVirtualQuery?

[AlexP]

Hello,

These properties are used to set insert/update/delete queries. If you haven't set these queries, they will be generated automatically. These queries are used when calling methods Insert[Append]/Edit/Delete.

[Eden0928]

Hello,

These properties are used to set insert/update/delete queries. If you haven't set these queries, they will be generated automatically. These queries are used when calling methods Insert[Append]/Edit/Delete.

We can get generated automatically SQL when Insert(Append).

The SQL can auto execute from sourceDataSet.connection? or Only history?

I have no idea about take the SQL can to do?

[AlexP]

Yes, if these properties are not set, SQL queries will be generated automatically. On query executing, VirtualQuery will refer to the already retrieved data in the dataset; the source dataset won't be re-opened or refreshed.