Need to move pixs in FoxProMac 2.6a into FPWin 2.6

[operaguy]

Legacy data transfer needed....Switching from FoxProMac 2.6 into ForProWin 2.6

Have a 1500 record file from FoxPro 2.6a Mac with images in a general field. When you click open the general field on the Mac, you see the image.

However, opening this table in FoxProWin 2.6, even though it shows a capital letter ("Gen"), error: "Invalid or corrupted OLE object."

Any help appreciated, including paid job for consultant.

Thank you,
John Donohue

 

[DSummZZZ]

General fields rely on opening the file embedded in them using the application associated with the file when it was stored in the general field.
In other words, say your computer is a Windows PC, and you have the file association for .BMP's set to use MS Paint. MS Paint must be installed on any computer that tries to open the general field.
So what that means is, in order to directly open the general field you are using on the MAC, you must have the same image editor/viewer installed on the PC as is used on the MAC.

There are threads outlining how to extract data from a general field, but it isn't easy. And the only ones I've seen are for PC's.
Your best bet may be to open each individually and save them separately, or maybe automate that process somehow, but there is no easy COPY TO ... type command.

This thread may help:
How to copy a GENERAL FIELD to BMP.file
thread182-118964




-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[operaguy]

Dave, thanks for responding.

The pictures are digital photos of industrial parts. I just sent a note to the client to see if a PC version of the program they are using with the camera is available (it almost certainly is.)

If we can get that PC version of the camera software and install it on the PC, perhaps that is all that is needed.

My question would be...according to the "same application" requirement you mentioned, I wonder if a PC version of the Mac version would be considered by FoxPro to be the "same application?"

John Donohue

 

[DSummZZZ]

My guess would be that it would work for you. As far as I know, Fox will mostly be paying attention to the application name as referenced in the table.

That said, I would highly recommend that you abandon the general field. They are too easily corrupted, cause excessive table bloat, and as you are finding out now, sometimes hard to work with.

A much better solution is to store the images separately and use a character field in lieu of the general field which contains the file name and path to each image. You can then reference the image file in your applications.




-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[operaguy]

Hmmm....but if just storing the link in a memo field, can that actual image be displayed on the face of a form, and can they click open the memo field from the browse and get the image itself, not the link?

That's for FoxPro Windows 2.6A, not VFP

John

 

[DSummZZZ]

No, I wouldn't use a memo field either. Just a plain character field.
What you do to display the image with Fox 2.x is something like:

@ nRow, nCol SAY myfile.myfield BITMAP

From there, you could create a command button (invisible on the image if you like) to display the image larger, or in the associated application.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm