1. O E
  2. PowerBuilder
  3. Tuesday, 16 June 2020 11:25 AM UTC

Hello,

how can i show a blob as picture? I saved a the blob in the database. I can select it per selectblob. I can show it in a window using Picture- or Inkpicture-Control. I can't show it in datawindow. I've tried TableBlob- and InkPicture-Control.

There's always a SQL-Select-Error State: 37000. Im using SQL-Anywhere 17. In database I've tried with varchar, binary and long binary.

Can someone help me out?

Attachments (1)
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 18 June 2020 16:51 PM UTC
  2. PowerBuilder
  3. # 1

What version of PowerBuilder? Newer versions have a 'Database Binary Object' control on the DataWindow that will autmatically do a SELECTBLOB and display it as a picture.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 16 June 2020 21:10 PM UTC
  2. PowerBuilder
  3. # 2

Hi O.E.;

   Since you are using "SQL-Anywhere 17" ... did you set the appropriate BLOB sizes in the DBMS connection?

   If you did not, the Blob data streams will terminate at 32K.  For example:

SQLCA.DBParm = ConnectString='XXXXXX',PBmaxblobsize='10000000',PBmaxtextsize='10000000'"

  Note: You may also modify the PBODBnnn.INI (where nnn= PB releease #) file for the above entries as well when using ODBC to connect. Please check your PB Help for more information.

Regards ... Chris

Comment
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Tuesday, 16 June 2020 13:30 PM UTC
  2. PowerBuilder
  3. # 3

Try writing the blob data to a file and displaying the file.

Comment
  1. O E
  2. Tuesday, 16 June 2020 14:21 PM UTC
Thanks for your reply.

I've got an solution with files on disk, but this isn't an option in this case.

In this case I need to show the picture without saving it to disk.
  1. Helpful
  1. Kevin Ridley
  2. Thursday, 18 June 2020 16:08 PM UTC
I don't know your requirements, but in the past I've deleted the file after displaying it.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.