Virtual table on Mydac Builder C++ 6

Virtual table on Mydac Builder C++ 6

Postby trayvou » Sun 24 Jul 2005 18:29

How to do select * from Virtualtable ?

Thanks
trayvou
 

Postby Ikar » Mon 25 Jul 2005 06:28

just set Active to True
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Virtual Table bcb C++6

Postby trayvou » Mon 25 Jul 2005 12:11

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
trayvou
 

Postby Ikar » Tue 26 Jul 2005 09:00

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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components