Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Adding BLOB Using ElevateDB Manager
Fri, Jan 18 2013 9:09 PMPermanent Link

Michael Riley

ZilchWorks

Avatar

I'm trying to add 3 BLOBs (15MB each) to a database table using the
ElevateDB Manager. How do I do this?

I've gotten as far as creating a table to store the BLOBs. Now I'm
stuck. Please help.

CREATE TABLE "MyBlobs"
(
"BlobName" VARCHAR(40) COLLATE "UNI",
"BlobNumber" INTEGER,
"RawData" BLOB
)
VERSION 1.00
READWRITE
UNENCRYPTED
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768!



--
Michael Riley
GySgt USMC Retired
http://capecodgunny.blogspot.com/
Fri, Jan 18 2013 11:31 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Michael,

Just open the table in EDB Manager (right click on it and choose Open Table).
Then click 2 times on the row you want to add, on the RawData column (to edit it) and then click the small button with the '...' caption; it's going to open an 'Edit BLOB' window where you are going to find an 'Import' button.

--
Fernando Dias
[Team Elevate]
Sat, Jan 19 2013 7:34 AMPermanent Link

Michael Riley

ZilchWorks

Avatar

Fernando Dias wrote:

>Just open the table in EDB Manager (right click on it and choose Open
>Table).  Then click 2 times on the row you want to add, on the
>RawData column (to edit it) and then click the small button with the
>'...' caption; it's going to open an 'Edit BLOB' window where you are
>going to find an 'Import' button.

Thank you Fernando

--
Michael Riley
GySgt USMC Retired
http://capecodgunny.blogspot.com/
Image