Select records from TDAMemDataTable

TIMOTHY_LAM · August 2, 2021, 12:01pm

Hi,
VirtualQuery doens’t support TDACDSDataTable. It must using Delphi standard dataset

EvgenyK · August 2, 2021, 12:02pm

Hi,

why you can’t pass to VirtualQuery memtable.dataset or cdstable.dataset ?
they are TDataset’s descendants.

TIMOTHY_LAM · August 2, 2021, 12:26pm

Hi,
VirtualQuery’s property can’t showing memtable or cdstable in the list. If I assign it by coding, it will show the error.
dataset

EvgenyK · August 2, 2021, 12:30pm

check DACDSDataTable1.Dataset.Name.
if it is empty then assign it.
as I understand, you should use

virtualquery1.SQL.Text := 'select * from '+DACDSDataTable1.Dataset.Name;

TIMOTHY_LAM · August 2, 2021, 12:40pm

Hi,
Thanks so much. It really works if I leave TDataSetLink empty and assign the statement like as your.

EvgenyK · August 2, 2021, 12:41pm

Hi,

try to use memtable instead of cdstable.
it also should work.

TIMOTHY_LAM · August 2, 2021, 12:43pm

Hi,
I tried that works too.