How to do select * from Virtualtable ?
Thanks
Virtual table on Mydac Builder C++ 6
Virtual Table bcb C++6
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 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