On So, 2015-06-21 at 14:01 -0700, aradeonas wrote: > Yes I went with TSQLQuery but problem is how to get insert query > automatically. So for example for Table1 without writing insert code I > get insert SQL code. > In lazarus database desktop tool,app do that but I can find out how to > to do like that.
You normally can do that using SQL, too. But the syntax varies, for SQLite this should be: "CREATE TABLE <new table name> AS SELECT * from <template table name> WHERE 0=1" The where clause may be rejected, choose a clause that does not return any columns or, if that doesn't create anything, one that returns only one or a few rows and delete them in the new table after creation ("DELETE * FROM <new table name>"). See: http://www.sqlite.org/lang_createtable.html Paragraph "CREATE TABLE ... AS SELECT Statements" Cheers, Marc -- Marc Santhoff <m.santh...@web.de> -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus