[fpc-pascal] Question with 2 different querys with Firebird

Eduardo Lopez edulopez at hotpop.com
Fri Oct 15 15:49:37 CEST 2004

Hello all:

I'm working with an application that must do 2 querys
I can connect with the Firebird DB, do the first query and all is ok.

   Query := TIBQuery.Create(nil);
   Query.Database := Database;
   Query.Transaction := Trans;
   Trans.Action := caCommitRetaining;
   Trans.Active := True;
   Query.SQL.Text := 'Select field1, field2, field3 from table1';
   While Not Query.Eof do
   Query.Sql.Text := '';

(all fine ...)

If I do a _second_ query to the same table, with the _same_ or _less_ 
fields it's ok.
But I can't do a query with others fields of the table:

Query.SQL.Text := 'Select field4, field5, from table1';
doesn't work, just tell me that can't find these fields.

The same things occurs if as _second_ query I try to do a search in 
another table, like:

Query.SQL.Text := 'Select field_a, field_b, from table2';

The question is:

What I am missing (or ignoring) to reset the query?
Actually to solve my problem I'm creating another query (Query2 
:=TIBQuery.Create(nil)) and using it, but I must create a query for each 
diferent access to the DB?

Thanks in advance. Eduardo.

More information about the fpc-pascal mailing list