Updating fields general

[Lengliz]

Hi,

I want update a general field (photo) that contains a JPG photo in my table customer
the structure of the table customer is the following:
- Code: C(12)
- Photo: general

To update the new photos in my table customer I use the following code:
----------------------------------------------------------
USE CUSTOMER
DO WHILE !EOF()
Ccode=custmer.Code && id custmer: "E123456987FG"
MyFile=Ccode+".jpg " && exp: E123456987FG.JPG
IF FILE(MyFile) && Test if the photo exists
APPEND GENERAL photo FROM LOCFILE(MyFile) LINK
ENDIF
SKIP
ENDDO
----------------------------------------------------------
When I display my customer's photos I see the name of the file photo (for example D2005E215445.JPG) instead the photo, however when I update by hand one by one the file using foxpro that works correctly.

Thank you
Mistral

 

[Mike Gagnon]

What application is associated with the image file? If you double-click on the image, what program starts? It is perhaps a wrong association. If so just change the association.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Lengliz]

When I clik on the image Iphoto Plus starts

 

[Mike Gagnon]

When I clik on the image Iphoto Plus starts

Then I would suggest you change the file association in both versions of the image to a common program likely to be found on all systems, like Microsoft Paint. Right-Mouse on the picture, go Open with->Choose a program and select Paint and select "Always use the selected program to open this type of file".

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Lengliz]

I am using VFP6 SP5

I tried with Paint but i don't work it shows the name of the file intead of of the image

Mistral