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. 6 days ago
Hello Chris.



the inkpicture control works perfect.



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









  1. Andres Slachevsky
  2. 6 days ago
????
  1. Chris Pollach
  2. 6 days ago
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.