| Author |
Message |
Anordlun
Joined: 13 Aug 2004
Posts: 12
|
 Posted: Fri Aug 13, 2004 10:43 am Post subject: Saving BLOBS to file. |
 |
|
Hi.
I have to download BLOB's larger than 32k and save them to file.
I've tried all known forums about dbExpress and search through Internet.
My last before dumping dbExpress is trying this forum?
Can anyone help me with this problem (I'm trying to download within Delphi)
//Andreas |
|
| Back to top |
|
 |
VISOCO Support
VISOCO Software Support
Joined: 16 Jul 2002
Posts: 96
|
| Posted: Tue Aug 17, 2004 10:35 am Post subject: |
|
|
We send you an example of work our dbExpress driver with BLOB by e-mail.
BLOB size is set in Params properties of TSQLConnections.
BlobSize parameter specifies the number of kilobytes. Try to set BlobSize=4096. This will be enough for 4 megabytes of BLOb data.
[/b] |
|
| Back to top |
|
|
Anordlun
Joined: 13 Aug 2004
Posts: 12
|
| Posted: Tue Aug 17, 2004 10:55 am Post subject: |
|
|
Thanks. That did the trick.
The helpfile did say that you should use -1 as blobsize.
| Quote: | | If MaxBlobSize is –1, the dataset imposes no maximum BLOB size. If MaxBlobSize is 0, the dataset uses the parameters of the associated SQL connection, if any, to determine the maximum BLOB size. |
Is this a limitation in the driver or in the Delphi component?
(Just curious) |
|
| Back to top |
|
|
Mat000
Joined: 04 Nov 2003
Posts: 12
|
| Posted: Tue Aug 24, 2004 10:31 am Post subject: |
|
|
There is a feature of the Sybase client API. The limit for the BLOb data must always be set.
BlobSize = -1 implies the default value (32K) |
|
| Back to top |
|
|
|
RSS Feed 
FAQ 
Search 
Memberlist 
Usergroups
Register
Profile 
Log in
