Zeoslib Portal

Hallo,
I have a TReadOnlyQuery with a doCachedLobs = True option.

When I try to do a ReadOnlyQuery.Refresh I get this exception: index out of bounds (3) on line 2366 in ZDbcCachedResultSet.pas file.

This exception results only if a record has a Blob field not null. If blob filed is null the exception is not raised.

I Compiled with Delphi 2010 + FB 2.5.5 and Zeos 7.2.0.3806.

What I'm wrong?

Thanks

@louis,

And how is in version 7.2.1-rc ie svn 3873?

Michal

Verified with latest 3877 revision but is the same

@louis,

Really.
There is a problem with the start of the application with the option doCachedLobs = True and full BLOB in first record.
However, if after the start (in runtime) Enable this option it work without error.

Michal

Hi louis,

thanks for pointing this issue out. Patch done R3878 \testing-7.2 (SVN)

note if you set this option zeos always loads the lobs for FB/PostgreSQL+OID-Lobs. If you do not use this option, Zeos just loads the lobs on demand.

Regards, Michael

EgonHugeist wrote:thanks for pointing this issue out. Patch done R3878 \testing-7.2 (SVN)

Not, I download Revision 3878 with TortoiseSVN.
TortoiseSVN updates revision from 3877 to 3878 but not shows which files was updated.
Clean, Build and reinstall Zeos package do not solves exception

Thanks.

miab3 wrote: There is a problem with the start of the application with the option doCachedLobs = True and full BLOB in first record.
However, if after the start (in runtime) Enable this option it work without error.

I Confirm, if I set doCachedLobs runtime it works, even in 3878 revision.

Thanks

Now you make me curious..

My patch should also work @design-time.. There was a EIndexOutOfBounds on accessing column-inforomations from a TObjectList if this option was set. So this is fixed now and i've added a huge test for all drivers to have a behavior control in future.

Maybe i missunderstand you. From what my tests do achieve with/without the option it should work properly now. Confirmed?

EgonHugeist wrote:the option it should work properly now. Confirmed?

Sorry but not, even il 3879 revision

I have this scenario:
1) a table (items) with more fields, one of them is a binary blob (image). this table is a foreighkey for another table (orders).
2) during populate "Orders" table by visual components, I need to see the image of the "Item" that I have editing in "Orders".
3) The image showed during editing of items in Orders is made with a TDBImage linked to a zReadOnlyQuery that have this sql code: "Select Image from Items where ID = :Item_ID"
4) during editing item row in "Orders" table i need to do a zReadOnlyQuery.Refresh in OnChanged of Item field of "Orders" table to link with ":Item_ID" parameter but Exception are made by line 2366 of code in ZDbcCachedResultSet.pas file (Delphi debugger stops here).

If i set doCachedLobs run-time I don't have exception.

Thanks

But than the issue is somewhere else and is unrelated to this option.

So it might be possible you're tracking a second issue. Louis could you make a little template app with a create-script or a ready database? Else i can't locate your problem..

@louis,

TortoiseSVN allows you to track changes.

Changes also see eg. here:
https://sourceforge.net/p/zeoslib/code-0/commit_browser

Michal

EgonHugeist wrote:Louis could you make a little template app with a create-script or a ready database? Else i can't locate your problem..

Ok, see attacked file.
Compile file, then click Button and obtain exception.

Thanks

@louis,

After throwing "mx-inventions" for me everything works without errors.
Can you give an example with error using the basic (standard) components?

Michal

miab3 wrote:@louis,

After throwing "mx-inventions" for me everything works without errors.
Can you give an example with error using the basic (standard) components?

Michal

Same from my side..

Oops, sorry. Force of habit.

See attacked file.

Thanks