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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.