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';
   Query.Open;
   While Not Query.Eof do
         ...
       Query.Next;
   end;
   Query.Close;
   Trans.Commit;
   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.