1. Andres Slachevsky
  2. PowerServer Web
  3. Thursday, 10 January 2019

Hello All,

I have a table with this sturcture:
CREATE TABLE "cmpu"."usuarios_fotos" ("usuario" char(5) NOT NULL DEFAULT NULL, "foto" long binary NOT NULL DEFAULT NULL, "fecha_insercion" timestamp DEFAULT "getdate"(), "usuario_insercion" varchar(5) DEFAULT current user, "fecha_modificacion" timestamp DEFAULT NULL, "usuario_modificacion" varchar(5) DEFAULT NULL , PRIMARY KEY ("usuario") , FOREIGN KEY "fk_usuarios_reference_usuarios" ("usuario" ) REFERENCES "cmpu"."usuarios" ON DELETE RESTRICT ) \

In client Server we use a Blob object in the Datawindow to update or retrieve the picture

it is not supported by PowerServer Web so i use a selectblob to get the value

following the documentation i try:

 

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 graph control have no setpicture function.

i try to save the blob in a file and then show the picture in a picture but it does not help

Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Andres;

   The "TableBlob" feature (which I think that you are talking about here) is not supported in PowerServer currently. If your Blob data is a picture. Then try using the InkPicture control for display (better than the regular picture control IMHO).

Regards ... Chris

 

Comment
More coffee ... works for me - LOL!



Yes, you can save a graph as a picture and then restore the graph image via that mechanism. I don't think though that this is what you are trying to accomplish. ;-)
  1. Chris Pollach
  2. Thursday, 10 January 2019
Hello Chris.



the inkpicture control works perfect.



but if you check PowerServer Documentation in the workaround i found this:









  1. Andres Slachevsky
  2. Thursday, 10 January 2019
????
  1. Chris Pollach
  2. Thursday, 10 January 2019
There are no comments made yet.
  1. Thursday, 10 January 2019
  2. PowerServer Web
  3. # 1
  • Page :
  • 1


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