Devart Forums

How to do select * from Virtualtable ?

Thanks

just set Active to True

select * from VirtualTable on a SQL Table doesn't work, the message is database.virtualtable doesn't exist.
VirtualTable is active.

Ex :

VirtualTable->Clear();
VirtualTable->AddField("MATERIEL", ftString, 30);
VirtualTable->AddField("TIROIR", ftString, 30);
VirtualTable->AddField("CARTE", ftString, 30);
VirtualTable->AddField("NOMENCLATURE", ftString, 30);
VirtualTable->AddField("TYPE", ftString, 30);
VirtualTable->AddField("FABRICANT", ftString, 30);
VirtualTable->AddField("VALIDE", ftString, 30);
VirtualTable->AddField("GMAO_COMP", ftString, 30);
VirtualTable-> Open();
VirtualTable->Active = true ;

MastData->CompQuery->SQL->Clear(); // MASTQuery
MastData->CompQuery->SQL->Add("Select * from VirtualTable");
MastData->CompQuery->Open(); // Message here on debug

With CompQuery a MyQuery Table and VirtualTable a VirtualTable.

Thanks

VirtualTable doesn't provide ability to copy data into DataSet. You have to copy data by single value.

To execute back task - pass data to VirtualTable use Assign method.