1. Sivaprakash BKR
  2. PowerBuilder
  3. Friday, 4 February 2022 06:31 AM UTC


PB 2019 R3, PostgreSQL 11

Got blob data in one of our tables where images are stored, which we are showing in two different ways.   The output looks different in the display size.   Why?

Left hand side:   which is a picture column [ Insert -> Control -> Picture ].  Read the blob data using selectblob write to an external file, assign the pathname to the picture control.

Right hand size:  Table blob column [ Insert -> Control -> Table Blob ].  

The issue is size.   The data stored in the blob is in 1170 x 1500 pixels.  The width and height in the corresponding data window are the same.   We tried resizing the width and height of the Table blob control.  No change.

We are in the process of converting the picture control to Table blob control, to avoid storing the data (again) in an external file.   Since it's a photo of students which, if resized, doesn't look good.  

Is there any reason why it's gets resized when showing as Table blob control?   Any solution?

Happiness Always
BKR Sivaprakash


Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 February 2022 14:24 PM UTC
  2. PowerBuilder
  3. # 1


   Did you select "Display Original Size"?

Regards ... Chris

  1. Sivaprakash BKR
  2. Thursday, 10 February 2022 06:16 AM UTC
Thanks Chris,

Original size will span a almost a full A4 size. Table Blob control could be resized, but image displayed inside the control is not resizing.

Now there is sufficient space in the table blob control to display the image, which is not being utilized(?).

  1. Helpful
  1. Sivaprakash BKR
  2. Thursday, 10 February 2022 06:17 AM UTC

Any Modify command exists which will resize the image's size inside the control to fit to the size of the control ?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 10 February 2022 15:21 PM UTC
The Modify() command can affect the Width & Height of the TableBlob column.

The other way around this that I have used in the past is to use the ImageMagicK (free open source tool) to introspect the image and then get it's size. From there, set the image's width & height from there.

Ideally though, the way forward could be to create an enhancement request for the TableBlob feature to allow "Original" size as a DWO property setting for this type of column data.
  1. Helpful 1
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.