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:
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
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. ;-)
the inkpicture control works perfect.
but if you check PowerServer Documentation in the workaround i found this: