1. Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 10 January 2019 17:55 PM UTC

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 @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 January 2019 19:01 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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
  1. Chris Pollach @Appeon
  2. Thursday, 10 January 2019 19:26 PM UTC
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. Helpful
  1. Andres Slachevsky
  2. Thursday, 10 January 2019 19:38 PM UTC
Hello Chris.



the inkpicture control works perfect.



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









  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 10 January 2019 20:17 PM UTC
????
  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.