Creating a Table from a Query Result Set?

I would like to automatically Create a table from a Delphi Query (to produce the same result that Paradox queryvar.executeQBE("NewTableName.db") produces).
Can you help?
rickofkirkwoodAsked:
Who is Participating?
 
dwwangCommented:
Since Delphi's LocalSQL does not support Select ... Into statements, you can use BatchMove:

Put a TBatchMove and a Ttable component on the form with the query, then set:

     BatchMove1.Source:=Query1;
     BatchMove1.Destination:=Table1;
     BatchMove1.Mode:=batCopy;
     Table1.TableName:='NewTable.DB';
     query1.sql.text:='Select * from employee where ...';
     query1.Open;
     BatchMove1.Execute;

Hopefully this is a easy way :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.