mercredi 21 janvier 2015

Alternative to Select Into

I'm using SQLite in a Delphi XE7 application and need to make a copy of 6 columns from one table into another table using the same types. If "Select Into" worked with SQLite, the SQL would look like:



SELECT
"RecNum",
"TK Number",
"Type",
"Disc.",
"Project Description",
"Date Added"
INTO
"CurrentLimited"
FROM
"Current"

The query is attached to a TQuery, so if there is a way to save the results of the TQuery as a table in the same database (I don't think SaveToFile offers that) then that would work too.


Aucun commentaire:

Enregistrer un commentaire