Copy field structure from table

[kenny]

Hi,
How do I copy the structure of particular table into virtual table? So that I can duplicate the record easyly.
Thanks

[Paul]

You can use Assign method of TVirtualTable to copy fields and data from other TDataSet component.

Code: Select all

OraQuery1.SQL.Text := 'SELECT * FROM DEPT';
OraQuery1.Active := True;
VirtualTable1.Assign(OraQuery1);
VirtualTable1.Active := True;