Can I use a Virtua Table in SQL Query???

Can I use a Virtua Table in SQL Query???

Postby JC » Fri 11 Nov 2005 13:23

Can I use a Virtua Table in SQL Query???
For example:
I have a virtual table:
vtTMP : TVirtualTable
With the following field
Field1 : integer;
Field2 : Integer;

Can I use a TMyQuery to do some since like it.

Select vtTMP.field1 from vtTMP

or use other sql sentence like insert o update.

I was try to use a insert sql sentence a I can not do it.

Please some body can help me .
Best Regard
JCarlos
JC
 

Postby Ikar » Fri 11 Nov 2005 15:19

TVirtualTable does not support SQL statements in any form.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components