Subject | Re: [IBO] "Blob Not Found" error on post to IBO dataset |
---|---|
Author | Chuck Belanger |
Post date | 2012-08-30T21:35:08Z |
Jason:
I was using a DSQL to Update a table for the blob changes while in an
editor, then using an existing function which took advantage of an open
IBO dataset to update the Date of changes to the record. That date
recording was using an Edit-Post combination.
I simply changed the function to a DSQL Update and all is well.
Apparently there was a previous conflict in ctNone in Checked and
IB_components which led me doing it this way. This conflict error is no
longer present in the new IBObjects, so it was not even an issue.
Thanks,
Chuck
I was using a DSQL to Update a table for the blob changes while in an
editor, then using an existing function which took advantage of an open
IBO dataset to update the Date of changes to the record. That date
recording was using an Edit-Post combination.
I simply changed the function to a DSQL Update and all is well.
Apparently there was a previous conflict in ctNone in Checked and
IB_components which led me doing it this way. This conflict error is no
longer present in the new IBObjects, so it was not even an issue.
Thanks,
Chuck
> Hi, Jason:
>
> I tried to make a simple sample app, but that did not show the bug.
>
> You are certainly welcome to do a remote of my desktop. I can leave my
> Delphi IDE open.
>
> Here is the steps to reproduce it:
>
> Run HealthCoach
> On Start Session dlg, select no patient selection
> On main form note left side has tree and right side has panels for
> showing the description associated with the tree nodes.
> Select on Left side tree, Products, then for our example, Interplexus,
> then Adapt.
> On right side simply type something in the description window (this is a
> wwDBMSWordRichEdit which is manually loaded during the tree
> OnFocusChanged event; it is not directly connected to the dataset.)
> Now go back to the left side and click on the next product down.
>
> The MainDescription RTF editor OnExit fires TreeView.SaveRTFChanges,
> which in turn fires TreeView.SetDateOfLastEdit which has a post after
> editing the modified date field. On the Post the error occurs.
>
> In SaveRTFChanges I use a IB_DSQL to update the ML_Item_Description
> field and commit that.
>
> I have madExcept trap errors so this is handy to see the location and
> calling sequence.
>
> What do I need to do at my end to allow you remote access?
>
> Maybe the above helps to explain the situation better, too?
>
> Chuck
>> I'm inclined to think this is a bug, but I'll need to know more about your
>> situation to tell for sure. Can you send me a sample app of this? Also,
>> perhaps I could remove view your machine and debug it right in place.
>>
>> Jason
>>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
>> Of Chuck Belanger
>> Sent: 28 August 2012 06:13 PM
>> To: IBObjects Listserve
>> Subject: [IBO] "Blob Not Found" error on post to IBO dataset
>>
>> Hello:
>>
>> Recently upgraded from D2007 to XE2 and upgraded to IBO 5.0 beta. The
>> code mentioned worked fine before.
>>
>> Using an IBOQry for the Woll2Woll component use.
>>
>> In a routine that saves a date to the dataset, on POST, I get "Blob not
>> found."
>>
>> There is a blob, ML_ITEM_DESCRIPTION. This shows up when I check
>> qryMLItem.Fields[x].name listing, but will throw the same error in the
>> IDE if I test qryMLItem.Fields[x].asString for the BLOB field during a
>> trace in the evaluate dialog.
>>
>> Perhaps this will help: ISC error: 335544382
>> IBOqrQryMLITEM_current Cursor_(TIB_BindingCursor)
>>
>> Is this a bug? any work around? or is there some expectation about using
>> IBO datasets that is different with v5.0?
>>
>> Thank you for your help,
>>
>> Chuck Belanger
>>
>>
>>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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
>>
>>
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>