Hello,

I have a problem with refresh.
Following situation:

var
query : tib_query;

begin
.......
query.sql.txt := 'select * from table1';
query.open;
......
query.insert;
query.fieldbyname('field1').asstring := 'xxx';
...
query.post;
query.refresh (true);
.....
end;

By calling the refresh (true) the insert is comitted, but all records
in the table are fetched after that.

When I use query.first instead of query.open, then only one record is
fetched wehn I call the refresh method.

I don't understand that. Could anybody Explain?

cu
Helmut