Hi,
If I execute the code bloew two times, only on the second time I receive back an error:
sqlite database schema has changed library routine called out of sequence
Tztable1.Append;
zconnection1.ExecuteDirect('CREATE TEMPORARY TABLE '+randomname('xx')+' AS select 1 from AZIENDA');
Tztable1.fieldbyname('CHIAVE').AsInteger:=key; // a correct key
Tztable1.Post;
The Tztable1 has a tablename and the temporary table is built on another table.
Any idea ?