Hi:
I´m working with Lazarus and SQLite tables.
I´m doing an application with Selection form, where I have a bottom to do a
query.
When pressed become active two tables with values to be charged and create a
new tables: tTemp2.
This query is a little complex, and the solution implemented is to charge in
the new table (tTemp2) some values. Then this is shown in a Report using
SQLQuery1.
When finished, I do
fdm.SQLQuery1.Close;
fdm.SQLTransaction1.Active := False;
fdm.SQLite3Connection1.Connected := False;
followed by
fdm.tTemp2.Close;
if fdm.ttemp2.TableExists then
begin
try
fdm.ttemp2.FileName := camino_BD + '\temp.db';
fdm.ttemp2.SQL := 'DROP TABLE Temp2';
fdm.ttemp2.ExecSQL;
except ShowMessagePos('No existe tTemp2',10,10);
end;
end else begin ShowMessagePos('al final de SelNSA temp2 no existe',10,10);
end;
It is expected to go back to the Selection form.
If I press for second time the botton for another query, the process start, but
the table tTemp2 can not be Active like the first time.
I will appreciate any suggestion.
Thanks in advance
Yours
Ing. Héctor F. Fiandor Rosario
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
