[sqlite] table can't be active

[hfiandor]

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