Image control problems

[WuzUp]

I am having a problem with the current image control on Visual FoxPro 5.0.

First It will only allow .bmp files to be viewed.

Second When I try to upload an image it hangs up on me and I need to shut it down.

It seems to have the biggest problem when requerying the database. The database is in Oracle.

Ideally I would like to be able to use .jpg file because of size. Does any one know how this can be done in FoxPro 5.0.

Thanks

 

[TomasDill]

Hi!

Upgrade to VF 6.0 that allows wider set of different image formats, include Jpg. It also much more reliable with images.

Its not a problem to query images from Orackle server. Just make a view and map general field in view usually returned from server binary field to memo field. Than using memo field in view and binary field on server you can store binary data and get it from server. On the client computer just copy memo field into the .Jpg temporary file (using strtofile() function) and show it in the image control.

If you want to use SPT cursors instead of remote views... Well, it is a bit tricky and hard. You can find a solution for such case at Universal Thread forum (

http://www.universalthread.com).

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[WuzUp]

Hey Tomas,
Thanks for the response. I found out however, that we are using FoxPro 6 and having a problem requerying the database once the image is saved. A co-worker of mine said that he did try a jpg file and it saved but froze on requerying the database. Now if you try to go back and view the image it freezes again. It really seems to have a problem with returning images. Any clue.

Thanks

 

[TomasDill]

No problems found in my application. Does that jpg image really opened by something other than VFP? I meant try following:

- Download data from server
- Same JPG content into the JPG file
- open JPG file by some viewer, for example, IE.

If you stuck on the data downloading from server - well, I cannot help here.

If you don't see image in IE, than it is corrupted.

Let me know what exactly a problem.
Give some specifics. For example: Which field you use on SQL Server to get image? How you show inmage on the local computer? Which field used on the local computer to store image and how you store it?



Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[DEDMOD]

Howcum you're trying(apparently) to store your .jpgs in the table instead of just referencing them? -- Dave

 

[TomasDill]

DEDMOD, see my first answer in this thread. You can see this in the FAQ section at the Universal thread site.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs