Link virtual table

Sawlmgsj · Post by **Sawlmgsj** » Tue 11 Jul 2006 11:00

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.

Antaeus · Post by **Antaeus** » Tue 11 Jul 2006 14:56

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.