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