ZEOSLIB, Delphi error: "close all lob streams before closing the resultset"

Question

I am getting this error when exiting my application. I am using delphi 7 with ZEOSLIB 8, PostgreSQL database ver 16.

The Delphi statement I use for loading blobs from database into bitbutton blobs is as follows:

DBtns[DCounter].Glyph.LoadFromStream( Datamod.tblChargeCodesgraphic.DataSet.CreateBlobStream( Datamod.tblChargeCodesgraphic , bmread ).Create );

The ZEOSLIB component method to read a blob from the the PostgreSQL database is createblobstream.

This line of code works perfectly, but how do I close the stream with a ZEOSLIB component method? I cannot find one, and ZConnect.CancelOperation does not work.

Laurenz Albe · Accepted Answer · 2025-02-20 07:19:27Z

0

Make sure to Free the TStream: Assign the result of CreateBlobStream() to a variable s and make sure (with a try - finally block) to call s.Free when you are done reading.

answered Feb 20 at 7:19

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Johan Bresler Feb 20 at 8:49

I my case s would be many arrays that must persist until form close. Apparently I will need to loop through and free every single element of the array of (graphic) blobs as the array variable does not have a a free method. Is there a faster way of doing that?

Laurenz Albe Feb 20 at 9:05

I don't know if there is a faster way.

Collectives™ on Stack Overflow

ZEOSLIB, Delphi error: "close all lob streams before closing the resultset"

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related