Page 1 of 1

Link virtual table

Posted: Tue 11 Jul 2006 11:00
by Sawlmgsj
Is it possible to link a virtual table with a table in my SQL database?
If so how do I use the components?

Thanks,
Steve.

Posted: Tue 11 Jul 2006 14:56
by Antaeus
VirtualTable component doesn't allow you to connect to the database directly, but you can request data from the server using one of our DAC products (SDAC, ODAC, MyDAC, IBDAC) and assign the data to VirtualTable:

Code: Select all

MSQuery.Open;
VirtualTable.Assign(MSQuery);
VirtualTable.Open;
After these operations you can work with data that VirtualTable already stores independently of the connection to the server.