Images in reports

Hi
I'm having a problem with a report that has an image field (VFP6)
On my system (xp pro) the report will show both jpg's and bmp's
On a number of my clients pc's, some can print the bmp's and some can print
the jpg's

Where it does not print, the image control simply shows a standard icon and
the name of the image

I cannot see anything in help or ms kb that deals with this
Any help appreciated

John Davy

Eric
Mon Nov 24 00:32:13 CST 2003

Hello, John!
You wrote on Mon, 24 Nov 2003 13:17:02 +1030:

JD> Where it does not print, the image control simply shows a standard icon
JD> and the name of the image
JD> I cannot see anything in help or ms kb that deals with this
JD> Any help appreciated

This is standard behavior when the OLE server that was used to store the
image in the table, is not (completely) installed on the other computer. It
is better not to use general fields at all. Instead, store your images in a
binary memo field and use FILETOSTR() and STRTOFILE() to get the file data
in and out.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

John
Mon Nov 24 19:58:02 CST 2003

Hi Eric

thanks for your help
I still have a problem though

The image control on my reports will only allow me to use a general field -
if it try to use a memo field it fails with the message that it must be a
general field

Is there a difference between memo fields and binary memo fields? - how do
you create / fill them?

John

"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> wrote in message
news:upED0SlsDHA.2136@TK2MSFTNGP10.phx.gbl...
> Hello, John!
> You wrote on Mon, 24 Nov 2003 13:17:02 +1030:
>
> JD> Where it does not print, the image control simply shows a standard
icon
> JD> and the name of the image
> JD> I cannot see anything in help or ms kb that deals with this
> JD> Any help appreciated
>
> This is standard behavior when the OLE server that was used to store the
> image in the table, is not (completely) installed on the other computer.
It
> is better not to use general fields at all. Instead, store your images in
a
> binary memo field and use FILETOSTR() and STRTOFILE() to get the file data
> in and out.
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>

Eric
Tue Nov 25 01:16:07 CST 2003

Hello, John!
You wrote on Tue, 25 Nov 2003 12:28:02 +1030:

JD> The image control on my reports will only allow me to use a general
JD> field - if it try to use a memo field it fails with the message that it
JD> must be a general field

JD> Is there a difference between memo fields and binary memo fields? - how
JD> do you create / fill them?

Here's a basic sample on how to print images stored in a binary memo field:
http://www.foxite.com/uploads/_2215n38q.zip
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

John
Tue Nov 25 15:50:30 CST 2003

Thanks Eric
It's all clear now

- I didn't know you sold boxer shorts..

Cheers
John


"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> wrote in message
news:OJ2VAQysDHA.684@TK2MSFTNGP09.phx.gbl...
> Hello, John!
> You wrote on Tue, 25 Nov 2003 12:28:02 +1030:
>
> JD> The image control on my reports will only allow me to use a general
> JD> field - if it try to use a memo field it fails with the message that
it
> JD> must be a general field
>
> JD> Is there a difference between memo fields and binary memo fields? -
how
> JD> do you create / fill them?
>
> Here's a basic sample on how to print images stored in a binary memo
field:
> http://www.foxite.com/uploads/_2215n38q.zip
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>