Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Error on update blob
Error on update blob
Posted: 2004/11/26 06:14
 
Hi to all,
I'm using Oracle 9, Delphi6 and Your componet (very good) but now I have a problem I don't understand.
I have to update a Blob field using this script:
select * from BOM_SIZE
where (BOM_ID = :BOM_ID)
and I write this code:
while not tblTgCompMisura.eof do begin
qryTgCompMisura.Locate('Position', tblTgCompMisuraATCSCO.AsString, []);
For J := 1 to Maxim do begin
qryBOM_SIZE.Locate('SIZE_', taglie[J],[]);
qryBOM_SIZE.Edit;
qryBOM_SIZECOMMENTS.Value := tblTgCompMisura.fieldByName('ATTST' + EsaDecDue[J]).AsString;
qryBOM_SIZE.Post;
end;
tblTgCompMisura.Next;
end;

When I debug I have this error on the post:
OCI129/Q Can not execute query, undefined key fields.
I never understand where is the problem
Thank you for the help
by
Boss
RE: Error on update blob
Posted: 2004/11/26 10:29
 
Hi !

Please, look http://www.da-soft.com/FAQ/KeyFields.html.

If you have more questions, please, ask.

Regards,
Dmitry