Blob field

[randallJ]

In VFP 9.0 can you use the Blob field to store images such as jpgs, gifs and bmps. If not what is the preferred data type to store these images.

 

[Stella740pl]

In most cases, I would keep images in a separate directory, and in the table, I would store a path to them in a character field. The table wouldn't grow as fast as with storing real images in fields of any type, and handling seems to be easier and faster.

 

[randallJ]

stella thank you for your reply. I understand fully what you mean and for that reason I do not store images in a permanent table -just the path. However I need the image which can vary in size and resolution to be centered on a full page and at present I can only do this by creating a temporary table and appending the image to a general field as only general fields have the ability to be centered.

 

[Mike Lewis]

RandallJ,

... only general fields have the ability to be centered

Are you sure about that? Couldn't you place a Picture field in the report, and set its Control Source Type to "Expression or variable name", then set the control source to the field that holds the filename?

I can't see why you couldn't centre the image in the page, just as you would if it was a General field. Then again, I've never tried doing that.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[randallJ]

Mike

Although the "centre general field horizontally in frame" box is activated when "Expression or variable name", is selected it only centres the image if it is a general field.