Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Dysplay BMP (signature) in a Datawindow

  1. How-to
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerBuilder
  3. Monday, 17 December 2018 16:58 PM UTC

Hello All,

i'm trying to follow the workaround documentation about the tablebloob object in a DW

following the documentation 

Large Binary/Text database OLE object

Description

The Large Binary/Text database OLE object for DataWindow is unsupported.

Workaround

This workaround only applies to the BitMap OLE object.

If a column with any large Binary/Text Database OLE object is used for displaying graphs, do the following steps to work around this issue:

Step 1: Replace the column with a Graph control.

Step 2: Retrieve the content of the column in the table related with the DataWindow using a SELECTBLOB SQL statement.

Step 3: Call the SetPicture function of this Graph control.

but the setpicture documentation refers only as a funcion to the picture control 

Please help!!

Silent Install available for AutoCompile?
Datawindow computed fields - performance issues.
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 17 December 2018 17:22 PM UTC
  2. PowerBuilder
  3. # 1

Hi Andres;

  FWIW: I have done this before in PB & PS by using the TableBlob and the InkPicture based DW & Control to deliver signature based images in my PB Apps.

Regards ... Chris

Comment
There are no comments made yet.
Andres Slachevsky
Andres Slachevsky Accepted Answer Pending Moderation
  1. Monday, 17 December 2018 17:44 PM UTC
  2. PowerBuilder
  3. # 2

it is SQL ANYWHERE 17 Database

the application using the TableBlob just do not dysplay any picture (as expected) 

i am trying to apply the Workaround but i can not find the setpicture for the graph i am trying with a picture in the main windows but my problem will be to dysplay it in the DW

the Signatures are saved as jpg in a blob column

Comment
There are no comments made yet.
Andres Slachevsky
Andres Slachevsky Accepted Answer Pending Moderation
  1. Monday, 17 December 2018 19:59 PM UTC
  2. PowerBuilder
  3. # 3

I found a workaround 

i read the Blob from the database

then create a file with the blob

in the datawindow i added a compute column in the properties i checked the display as picture

and set the name of the save file to the column 

Comment
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.