Solved

Too Many Blobfields Open

Posted on 1997-05-07
4
192 Views
Last Modified: 2010-04-06
After we have printed several reports using rppro 2.0g we get the too many Blobfields open error and have to terminate the app in order to restore the system resources. The error occurs after about seven or so printouts on a 24 MB system.
We have narrowed this error down to what we believe is a database problem. One of our tables has a blobfield in the record. I believe this occurs on the following section of code.
Ch1BlobStream := TBlobStream.Create(MyoexorciserMain.TreatmentsCh1SessData, bmRead);
   Ch2BlobStream := TBlobStream.Create(MyoexorciserMain.TreatmentsCh2SessData, bmRead);
   Ch1BlobStream.Read(Ch1Array^, TotalPoints);
   Ch2BlobStream.Read(Ch2Array^, TotalPoints);
   MyoexorciserMain.Treatments.Cancel;
   Ch1BlobStream.Free;
   Ch2BlobStream.Free;

The arrays which are being assigned to the blobstreams are defined as follows:
{allocate storage for the raw channel data}
   Ch1Array, Ch2Array: PChanArray;
.....
PChanArray = ^TChanArray;
   TChanArray = Array[0..Max] of Byte; { MAX = 65,000}
   PAdaptArray = ^TAdaptArray;  

Is there a problem in the way we are assigning the arrays to the blobstreams? Does Delphi really free up these blobstreams and if so why do we get this error?

BTW we were unable to get the SET method to work for assigning the dynamic array directly to the bloblstream and the use of the filestream was very slow, although at this juncture I am open to any work around.
0
Comment
Question by:billmee
  • 3
4 Comments
 

Author Comment

by:billmee
ID: 1335996
Edited text of question
0
 

Author Comment

by:billmee
ID: 1335997
Edited text of question
0
 

Author Comment

by:billmee
ID: 1335998
Incidentally, if we access the same record more than three times we get an exception violation.  The Too Many Bloblfiels open error is good for about 7 - 10 accesses of different records, if this is any help
0
 
LVL 3

Accepted Solution

by:
sperling earned 220 total points
ID: 1335999
Try not cancelling until you've freed the blobstreams. Might help, but I'm not sure.

Regards,

Erik.

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now