Image is not changing for each record in a report

The information suggested by Lee Mitchell in his reply to the following post was very helpful in solving my issue with presenting images stored in a general table field into a report

Subject: RE: Image Click Code To Transfer A Jpeg Into A General Or Binary Field In A Table 5/19/2004 10:29 AM PST

I now have my images stored in a binary memo field (froogle.newpath), and have written the following, simple program function to extract the image into a file called bob.jpg

PROCEDURE bertudf(lpFileName, lpMemoBinFld
DELETE FILE bob.jp
SET SAFETY of
STRTOFILE(lpMemoBinFld, "bob.jpg"
SET SAFETY o
RETURN lpFileName

My OLEBOUND report control points to "file" with the following reference

bertudf("bob.jpg",froogle.newpath) where "froogle" is the table name and "newpath" is the binary memo field containing the image

I know the UDF is being called and is working, because the image in "bob.jpg" is changing when it is opened from Windows Explorer and the status bar shows File Deleted (as called for in the UDF) as I step through the pages when previewing the report. I put that delete file step in to make sure the file is actually changing.

All of the data in the report is changing appropriately as each table record is reported, except for the image. Only the image for the first record is displayed, and is repeated for each subsequent record in the report. When I Preview the image inside of the OLEBOUND report control, it displays the first record's image (which is not the latest image displayed in Windows Explorer)

What am I missing to get the reported images to match with the other data being reported?

Gregory
Sat May 22 03:41:10 CDT 2004

Bert,

pictures are cached. I think a [clear RESOURCES bob.jpg] will do as
indicated below

Gregory
_____________

"Bert Knight" <anonymous@discussions.microsoft.com> wrote in message
news:90ADC45B-2248-4071-9161-0D0DAD62F213@microsoft.com...
> The information suggested by Lee Mitchell in his reply to the following
post was very helpful in solving my issue with presenting images stored in a
general table field into a report:
>
> Subject: RE: Image Click Code To Transfer A Jpeg Into A General Or Binary
Field In A Table 5/19/2004 10:29 AM PST
>
> I now have my images stored in a binary memo field (froogle.newpath), and
have written the following, simple program function to extract the image
into a file called bob.jpg:
>
> PROCEDURE bertudf(lpFileName, lpMemoBinFld)
> DELETE FILE bob.jpg

clear RESOURCES bob.jpg

> SET SAFETY off
> STRTOFILE(lpMemoBinFld, "bob.jpg")
> SET SAFETY on
> RETURN lpFileName
>
> My OLEBOUND report control points to "file" with the following reference:
>
> bertudf("bob.jpg",froogle.newpath) where "froogle" is the table name and
"newpath" is the binary memo field containing the image.
>
> I know the UDF is being called and is working, because the image in
"bob.jpg" is changing when it is opened from Windows Explorer and the status
bar shows File Deleted (as called for in the UDF) as I step through the
pages when previewing the report. I put that delete file step in to make
sure the file is actually changing.
>
> All of the data in the report is changing appropriately as each table
record is reported, except for the image. Only the image for the first
record is displayed, and is repeated for each subsequent record in the
report. When I Preview the image inside of the OLEBOUND report control, it
displays the first record's image (which is not the latest image displayed
in Windows Explorer).
>
> What am I missing to get the reported images to match with the other data
being reporte

anonymous
Mon May 24 08:06:04 CDT 2004

Gregory

Your adivce was absolute dead on! I added that one simple line of code, and now the image changes as expected

Thank
Ber

----- Gregory Adam wrote: ----

Bert

pictures are cached. I think a [clear RESOURCES bob.jpg] will do a
indicated belo

Gregor
____________

"Bert Knight" <anonymous@discussions.microsoft.com> wrote in messag
news:90ADC45B-2248-4071-9161-0D0DAD62F213@microsoft.com..
> The information suggested by Lee Mitchell in his reply to the followin
post was very helpful in solving my issue with presenting images stored in
general table field into a report
>> Subject: RE: Image Click Code To Transfer A Jpeg Into A General Or Binar
Field In A Table 5/19/2004 10:29 AM PS
>> I now have my images stored in a binary memo field (froogle.newpath), an
have written the following, simple program function to extract the imag
into a file called bob.jpg
>> PROCEDURE bertudf(lpFileName, lpMemoBinFld
> DELETE FILE bob.jp

clear RESOURCES bob.jp

> SET SAFETY of
> STRTOFILE(lpMemoBinFld, "bob.jpg"
> SET SAFETY o
> RETURN lpFileNam
>> My OLEBOUND report control points to "file" with the following reference
>> bertudf("bob.jpg",froogle.newpath) where "froogle" is the table name an
"newpath" is the binary memo field containing the image
>> I know the UDF is being called and is working, because the image i
"bob.jpg" is changing when it is opened from Windows Explorer and the statu
bar shows File Deleted (as called for in the UDF) as I step through th
pages when previewing the report. I put that delete file step in to mak
sure the file is actually changing
>> All of the data in the report is changing appropriately as each tabl
record is reported, except for the image. Only the image for the firs
record is displayed, and is repeated for each subsequent record in th
report. When I Preview the image inside of the OLEBOUND report control, i
displays the first record's image (which is not the latest image displaye
in Windows Explorer)
>> What am I missing to get the reported images to match with the other dat
being report

anonymous
Mon May 24 11:56:03 CDT 2004

An interesting result of switching from General fields to BinaryMemo fields (besides resolving the problem of not being able to see images on machines other than the one that populated the General field) - the time it takes to populate the data table fell from 1 hr 15 minutes to 6 minutes.

Thanks again

Bert Knight