Page 1 of 1
When use SQLInsert, SQLDelete... From TVirtualQuery
Posted: Wed 06 Jul 2016 08:17
by Eden0928
Could you tell me about when use property: SQLInsert, SQLDelete, SQLUpdate from TVirtualQuery?
Re: When use SQLInsert, SQLDelete... From TVirtualQuery
Posted: Wed 06 Jul 2016 08:47
by 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.
Re: When use SQLInsert, SQLDelete... From TVirtualQuery
Posted: Wed 06 Jul 2016 09:03
by Eden0928
AlexP wrote: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?
Re: When use SQLInsert, SQLDelete... From TVirtualQuery
Posted: Thu 07 Jul 2016 09:01
by 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.