When use SQLInsert, SQLDelete... From TVirtualQuery
When use SQLInsert, SQLDelete... From TVirtualQuery
Could you tell me about when use property: SQLInsert, SQLDelete, SQLUpdate from TVirtualQuery?
Re: When use SQLInsert, SQLDelete... From TVirtualQuery
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.
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
We can get generated automatically SQL when Insert(Append).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.
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
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.