Is it possible to fill a virtualtable with the content of a TPgQuery ?
Thanks,
TVirtualTable.LoadFromDataset ?
Re: TVirtualTable.LoadFromDataset ?
You can read on how to fill TVirtualTable with data from TPgQuery in the VirtualTable help: https://www.devart.com/vtable/docs/tvir ... assign.htm
Re: TVirtualTable.LoadFromDataset ?
Oops, sorry I missed it in the docs. Thanks !
Re: TVirtualTable.LoadFromDataset ?
Feel free to contact us if you have any further questions.
Re: TVirtualTable.LoadFromDataset ?
https://www.devart.com/virtualdac/docs/ ... bject).htm
You may set Query1.Options.SetFieldsReadOnly to false in order to edit fields in the virtual table, that are calculated fields in the query. For example:
Here you can edit the "yes" field in order to mark it as to be changed later in some database source table or so.
You may set Query1.Options.SetFieldsReadOnly to false in order to edit fields in the virtual table, that are calculated fields in the query. For example:
Code: Select all
Query1.Options.SetFieldsReadOnly := false;
Query1.SQL.Text := 'SELECT foo, true AS yes FROM bar';
Query1.Open;
VTable1.Assign(Query1);
VTable1.Open; // <= in contrast to the clientdataset you have to open the virtual table explicitly
Re: TVirtualTable.LoadFromDataset ?
VirtualQuery cannot be linked to a specific data source, unlike ClientDataSet, which results in such behavior.