Discussion:
Displaying images stored in database
(too old to reply)
Carl
2009-08-11 16:24:38 UTC
Permalink
I have a table that stores images in a blob, which I would like to display
in a report.

The only control that seems to support displaying images from a DB is the
InkPicture control. When I add this to the report, it simply displays a
white box, no image.

Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.

Thanks,

Carl.
Chris Pollach
2009-08-17 17:50:41 UTC
Permalink
Hi Carl;

There is no direct support in IM to display pictures stored in a BLOB
(binary) based column. This is supported in IM's big brother PowerBuilder as
you can use the SelectBlob and SetPicture ( ) commands to handle the blob
based image.

The only support in IM is the "Display as Picture" property in any DB
column. However, this indicates that the name of the image file is stored on
the DB and this will be resolved locally by IM at run time. This means that
this feature is only good to point to an image on a file server for example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to display
in a report.
The only control that seems to support displaying images from a DB is the
InkPicture control. When I add this to the report, it simply displays a
white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Carl
2009-08-21 15:46:31 UTC
Permalink
Then what is the purpose/use of the InkPicture control?

Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a BLOB
(binary) based column. This is supported in IM's big brother PowerBuilder
as you can use the SelectBlob and SetPicture ( ) commands to handle the
blob based image.
The only support in IM is the "Display as Picture" property in any DB
column. However, this indicates that the name of the image file is stored
on the DB and this will be resolved locally by IM at run time. This means
that this feature is only good to point to an image on a file server for
example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to display
in a report.
The only control that seems to support displaying images from a DB is the
InkPicture control. When I add this to the report, it simply displays a
white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Chris Pollach
2009-08-21 17:53:29 UTC
Permalink
Hmmm .. in IM - that is a good question.
I have never used it in IM. I wonder if anyone can "chime in" here and give
us an example.
Post by Carl
Then what is the purpose/use of the InkPicture control?
Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a BLOB
(binary) based column. This is supported in IM's big brother PowerBuilder
as you can use the SelectBlob and SetPicture ( ) commands to handle the
blob based image.
The only support in IM is the "Display as Picture" property in any DB
column. However, this indicates that the name of the image file is stored
on the DB and this will be resolved locally by IM at run time. This means
that this feature is only good to point to an image on a file server for
example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to
display in a report.
The only control that seems to support displaying images from a DB is
the InkPicture control. When I add this to the report, it simply
displays a white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Carl
2009-08-21 18:03:30 UTC
Permalink
That's what I'm hoping for...

Anyone...?

Carl.
Post by Chris Pollach
Hmmm .. in IM - that is a good question.
I have never used it in IM. I wonder if anyone can "chime in" here and
give us an example.
Post by Carl
Then what is the purpose/use of the InkPicture control?
Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a BLOB
(binary) based column. This is supported in IM's big brother
PowerBuilder as you can use the SelectBlob and SetPicture ( ) commands
to handle the blob based image.
The only support in IM is the "Display as Picture" property in any DB
column. However, this indicates that the name of the image file is
stored on the DB and this will be resolved locally by IM at run time.
This means that this feature is only good to point to an image on a file
server for example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to
display in a report.
The only control that seems to support displaying images from a DB is
the InkPicture control. When I add this to the report, it simply
displays a white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Bryan Gardner
2009-08-21 18:20:12 UTC
Permalink
From the User Guide...

The InkPicture control is designed for use on a Tablet PC and provides the
ability to capture ink input from users of Tablet PCs. The control displays
signatures, drawings, and other annotations that do not need to be
recognized as text.

You use an InkPicture control with a table that has a blob column to store
the ink data, and optionally a second blob column to provide a background
image. The InkPicture control behaves like a Picture control that can
contain annotation. You can associate a picture with the control to display
annotations that have been saved with the picture. If the control contains
signatures, you usually do not associate a picture with it.

To add an InkPicture control to a report, select Insert>Control>InkPicture
from the menu. A dialog box displays to let you specify a blob column to
store the ink data and another to use as a background image. After you
specify the columns in the dialog box, the InkPicture control displays in
the DataWindow and its Properties view includes a Definition tab page where
you can view or change the column definitions.
Post by Carl
That's what I'm hoping for...
Anyone...?
Carl.
Post by Chris Pollach
Hmmm .. in IM - that is a good question.
I have never used it in IM. I wonder if anyone can "chime in" here and
give us an example.
Post by Carl
Then what is the purpose/use of the InkPicture control?
Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a
BLOB (binary) based column. This is supported in IM's big brother
PowerBuilder as you can use the SelectBlob and SetPicture ( ) commands
to handle the blob based image.
The only support in IM is the "Display as Picture" property in any
DB column. However, this indicates that the name of the image file is
stored on the DB and this will be resolved locally by IM at run time.
This means that this feature is only good to point to an image on a
file server for example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to
display in a report.
The only control that seems to support displaying images from a DB is
the InkPicture control. When I add this to the report, it simply
displays a white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Carl
2009-08-21 18:40:35 UTC
Permalink
Thank you, but I've been down that path. I've added the InkPicture control,
and set it up to pull data from my blob columns, but it does not display a
picture, only white space. I know the data in the blob is valid, as I've
written a .net app that displays the data with no problem.

I've tried both PB and IM, and cannot get the InkPicture control to display
a picture. Can someone help with that, or suggest another control that I
can use to display blob data from a DB as a picture?

Carl.
Post by Bryan Gardner
From the User Guide...
The InkPicture control is designed for use on a Tablet PC and provides the
ability to capture ink input from users of Tablet PCs. The control
displays signatures, drawings, and other annotations that do not need to
be recognized as text.
You use an InkPicture control with a table that has a blob column to store
the ink data, and optionally a second blob column to provide a background
image. The InkPicture control behaves like a Picture control that can
contain annotation. You can associate a picture with the control to
display annotations that have been saved with the picture. If the control
contains signatures, you usually do not associate a picture with it.
To add an InkPicture control to a report, select Insert>Control>InkPicture
from the menu. A dialog box displays to let you specify a blob column to
store the ink data and another to use as a background image. After you
specify the columns in the dialog box, the InkPicture control displays in
the DataWindow and its Properties view includes a Definition tab page
where you can view or change the column definitions.
Post by Carl
That's what I'm hoping for...
Anyone...?
Carl.
Post by Chris Pollach
Hmmm .. in IM - that is a good question.
I have never used it in IM. I wonder if anyone can "chime in" here and
give us an example.
Post by Carl
Then what is the purpose/use of the InkPicture control?
Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a
BLOB (binary) based column. This is supported in IM's big brother
PowerBuilder as you can use the SelectBlob and SetPicture ( ) commands
to handle the blob based image.
The only support in IM is the "Display as Picture" property in any
DB column. However, this indicates that the name of the image file is
stored on the DB and this will be resolved locally by IM at run time.
This means that this feature is only good to point to an image on a
file server for example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to
display in a report.
The only control that seems to support displaying images from a DB is
the InkPicture control. When I add this to the report, it simply
displays a white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Chris Pollach
2009-08-24 10:59:41 UTC
Permalink
That only works in a form AFAIK - same for an OLE picture - when you
double-click it opens up the associated tool to display the image.
Post by Carl
Thank you, but I've been down that path. I've added the InkPicture
control, and set it up to pull data from my blob columns, but it does not
display a picture, only white space. I know the data in the blob is
valid, as I've written a .net app that displays the data with no problem.
I've tried both PB and IM, and cannot get the InkPicture control to
display a picture. Can someone help with that, or suggest another control
that I can use to display blob data from a DB as a picture?
Carl.
Post by Bryan Gardner
From the User Guide...
The InkPicture control is designed for use on a Tablet PC and provides
the ability to capture ink input from users of Tablet PCs. The control
displays signatures, drawings, and other annotations that do not need to
be recognized as text.
You use an InkPicture control with a table that has a blob column to
store the ink data, and optionally a second blob column to provide a
background image. The InkPicture control behaves like a Picture control
that can contain annotation. You can associate a picture with the control
to display annotations that have been saved with the picture. If the
control contains signatures, you usually do not associate a picture with
it.
To add an InkPicture control to a report, select
Insert>Control>InkPicture from the menu. A dialog box displays to let you
specify a blob column to store the ink data and another to use as a
background image. After you specify the columns in the dialog box, the
InkPicture control displays in the DataWindow and its Properties view
includes a Definition tab page where you can view or change the column
definitions.
Post by Carl
That's what I'm hoping for...
Anyone...?
Carl.
Post by Chris Pollach
Hmmm .. in IM - that is a good question.
I have never used it in IM. I wonder if anyone can "chime in" here and
give us an example.
Post by Carl
Then what is the purpose/use of the InkPicture control?
Carl.
Post by Chris Pollach
Hi Carl;
There is no direct support in IM to display pictures stored in a
BLOB (binary) based column. This is supported in IM's big brother
PowerBuilder as you can use the SelectBlob and SetPicture ( )
commands to handle the blob based image.
The only support in IM is the "Display as Picture" property in any
DB column. However, this indicates that the name of the image file is
stored on the DB and this will be resolved locally by IM at run time.
This means that this feature is only good to point to an image on a
file server for example.
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Carl
I have a table that stores images in a blob, which I would like to
display in a report.
The only control that seems to support displaying images from a DB
is the InkPicture control. When I add this to the report, it simply
displays a white box, no image.
Is there a better control to use? If not, why is the InkPicture not
displaying my image. I've tried this in Infomaker 10.5 and PB 11.2.
Thanks,
Carl.
Loading...