Thanks we will try and see if we can get it to work like this.


At 12:52 PM 27/02/2006, you wrote:

>Johannes Pretorius wrote:
>
>> 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
>
>I've had this a couple of times in the past, and it was caused by duff
>saves to the blob. I ended up just deleting the blob reference from
>IB_SQL and creating a new record, but I suspect you are seeing something
>slightly different. One possible 'cause' may be that the blob id's are
>getting messed up.
>
>Could you build the data for blob you want to save in memory and then
>save the results, so you are not using multiple blob id's at the same time?
>
>Bear in mind that 5.6 *IS* an old version of Interbase and I think the
>errors I saw WERE probably from that time, so this may just be something
>that was never fixed in Interbase!
>
>--
>Lester Caine - G8HFL
>-----------------------------
>L.S.Caine Electronic Services
>Treasurer - Firebird Foundation Inc.
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>