| Subject | IB_Query.InvalidateSQL and Refresh |
|---|---|
| Author | |
| Post date | 2015-08-18T20:44:09Z |
Version: 4.9.10
I used to use this construction frequently:
with IB_Query do begin
InvalidateSQL;
Refresh;
end;
this is when
procedure TIB_Dataset.Open; was just that but now
Version: 5.7.5 2275
with
procedure TIB_Dataset.Open( const ABookmark: RawByteString;
const ARefineStr: string;
const ARowNum: integer );
On large tables - IBO just spins endlessly on IB_Dataset.Open
The query never gets dispatched to the server.
I've had to change the previous construction to:
with IB_Query do begin
InvalidateSQL;
IB_Transaction.Refresh(True); //Refresh;
end;
You don't see it causing issue too much on very small datasets. It's not always an issue but on large sets it's a killer.
Is this by design? Are we aware of this?
Alan