Hey José! You may alter the data type for "image content" to expand beyond 32 kB.

My test table supports files up to 2 GB each. Code here is for SQL Anywhere 17.

CREATE TABLE "test_file"(
   "file_ID"  integer  not null DEFAULT autoincrement,
   "filename" varchar(260) null,
   "content"  long binary  null,  /* varbinary(max) in MSSQL.   BLOB in Oracle SQL */
   primary key ("file_ID"));

HTH /Michael

Thanks for all answer, I resolved the issue, the problem was the image size, I had to control that it's low or 32K to show, and I changed InkPicture for p_1.SetPicture. 

Thanks very much

Hi José;

  If you are using SA (formerly called ASA) and thus ODBC  ... did you set the BLOB length to go beyond 32K (its SA default)?

Regards ... Chris

Hey José,

I have expanded my tiny demo app with both JPG and PNG files. Here is what I have working:

• Load directly from file into InkPicture
• Load via BLOB variable into InkPicture
• Save to SQL Anywhere 17 database from file
• Load from SQL Anywhere 17 database into InkPicture

Let me know if you want my demo-app for comparison. I will add a button to create the test table I'm using before uploading. I use really ordinary SQL in the app so it should work in older SQL Any databases - or even in other DBMS as long as you substitute the datatype for the BLOB column to whatever BLOB type that DBMS is using.

HTH /Michael

Greetings, Jose -

Have you considered using a Picture control instead of the InkPicture control? It supports JPEG's, and you can load a blob containing the image into a Picture control via its SetPicture function.

Hi Michael, thankyou for answer. I'm usign Sybase ASA 9, de datatype is Long Binary, I inserted an image JPG in this colum

Regards

You loaded the BLOB value from the database. What kind of data was stored in that BLOB field? 

BLOB being just a chunk of memory I guess it may be ill-formatted for the InkPicture image.

/Michael