CreateBlobStream, Stream Size

Question

My Code:

 stream := qry.CreateBlobStream(qry.FieldByName('aaa'), bmRead);

The record in aaa is actually bigger than the stream's size,which is always 32786.Why?

Do we need more details? Like Delphi version. Which DB framework? Which DB? — David Heffernan, Dec 26 '12 at 08:25
And I Mean stream's size is alway's 32768 bytes;And the Real lenth of record AAA is much bigger! — EdiJXu, Dec 26 '12 at 08:28
The BDE is like smoking. If you aren't doing it, don't start. If you are doing it, quit right away. — Nick Hodges, Dec 27 '12 at 14:20

score 3 · Accepted Answer · answered Dec 26 '12 at 08:34

3

According to my web searches, you need to increase the BLOB SIZE parameter in the BDE administrator:

The first of these threads suggests an alternative approach of setting RequestLive of the TQuery to be True.

The second thread dates from 1902 which would appear to be a rare sighting in the wild of the Y2K bug!

answered Dec 26 '12 at 08:34

David Heffernan

Thanks，it works! I just changed BLOB SIZE to 128!@David Heffernan – EdiJXu Dec 26 '12 at 08:56

1 Answers1