Subject | [IBO] BLOB is not refreshing |
---|---|
Author | Petr Hartman |
Post date | 2005-04-29T06:27:38Z |
Hi all,
I have one problem. I'll try to explain it on simple example.
I have TIB_Query. SQL is 'select TEXT from RECEPT', where TEXT is type BLOB SUB_TYPE 1.
I perform this commands:
IB_Query1.Append;
IB_Query1.FieldByName('TEXT').asString := 'something';
IB_Query1.Cancel;
while not IB_Query1.BOF do
begin
ShowMessage(IB_Query1.FieldByName('TEXT').asString);
IB_Query1.Prior;
end;
Each ShowMessage command shows the same content 'something'! (althoug there is, in fact, another content).
The problem disappears, when I reach BOF.
Does anybody know where is the problem?
Best regards
Petr Hartman
I have one problem. I'll try to explain it on simple example.
I have TIB_Query. SQL is 'select TEXT from RECEPT', where TEXT is type BLOB SUB_TYPE 1.
I perform this commands:
IB_Query1.Append;
IB_Query1.FieldByName('TEXT').asString := 'something';
IB_Query1.Cancel;
while not IB_Query1.BOF do
begin
ShowMessage(IB_Query1.FieldByName('TEXT').asString);
IB_Query1.Prior;
end;
Each ShowMessage command shows the same content 'something'! (althoug there is, in fact, another content).
The problem disappears, when I reach BOF.
Does anybody know where is the problem?
Best regards
Petr Hartman