Solved

Too Many Blobfields Open

Posted on 1997-05-07
4
193 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

929 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