Subject | Re:Invalid Blob ID |
---|---|
Author | Johannes Pretorius |
Post date | 2006-02-27T10:03Z |
Good day all
=-0=-00-=-0==-0
we have an odd error happening with IBObject 4.6A and Interbase 5.6
//==== ERROR =================
isc error code:335544329
isc error message:
invalid blob id
statement:
tib_statement: "<tapplication>.dm.qreports.iboqrqreports.<tib_updatesql>.<tib_statement>."
statement:
tibointernaldataset: "<tapplication>.dm.qreports.iboqrqreports."
//= EINDE ===================
We have noticed this previously and believed it had to do with the Template that is a
blob field being pulled from a stored procedure and then copy with the function
//=== FUnKSIE ================
QReports.CreateBlobStream(QReports.FieldByName('REPORT'),bmWrite).CopyFrom(QTemplates.CreateBlobStream(QTemplates.FieldByName('TEMPLATE'),bmRead),QTemplates.CreateBlobStream(QTemplates.FieldByName('TEMPLATE'),bmRead).size);
//=== EINDE ==================
We then changed the code so that the Templates came from a Query and NOT a stored procedure and it seemed asif the problem has come back again.
Notice that the problem happens when we try and SAVE the Qreports data.
If anybody can give us some hints or idea's to start solving this problem please.
Thanks in Advance
Johannes Pretorius
(Programeerings Departement- Promed)
Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste : http://www.promed.co.za
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you
[Non-text portions of this message have been removed]
=-0=-00-=-0==-0
we have an odd error happening with IBObject 4.6A and Interbase 5.6
//==== ERROR =================
isc error code:335544329
isc error message:
invalid blob id
statement:
tib_statement: "<tapplication>.dm.qreports.iboqrqreports.<tib_updatesql>.<tib_statement>."
statement:
tibointernaldataset: "<tapplication>.dm.qreports.iboqrqreports."
//= EINDE ===================
We have noticed this previously and believed it had to do with the Template that is a
blob field being pulled from a stored procedure and then copy with the function
//=== FUnKSIE ================
QReports.CreateBlobStream(QReports.FieldByName('REPORT'),bmWrite).CopyFrom(QTemplates.CreateBlobStream(QTemplates.FieldByName('TEMPLATE'),bmRead),QTemplates.CreateBlobStream(QTemplates.FieldByName('TEMPLATE'),bmRead).size);
//=== EINDE ==================
We then changed the code so that the Templates came from a Query and NOT a stored procedure and it seemed asif the problem has come back again.
Notice that the problem happens when we try and SAVE the Qreports data.
If anybody can give us some hints or idea's to start solving this problem please.
Thanks in Advance
Johannes Pretorius
(Programeerings Departement- Promed)
Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste : http://www.promed.co.za
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you
[Non-text portions of this message have been removed]