Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append General Field
Message
From
08/09/2006 22:50:59
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
08/09/2006 20:22:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152494
Message ID:
01152502
Views:
19
Most experienced developers over here agree that you should usually avoid General fields. Instead, keep the BMP or JPG in a separate file, and store only the filename in your database.

The reasons to avoid General fields are mainly: 1) They use up too much space, 2) It is difficult to get an image or other object back out of the General field.

>I have create a table with a general type field and on the OLE-OBJECT I have selected "Stretch = 2".
>
>Example of code I am using - see below.
>***************************************
>PUBLIC cAppImage
>select Book_Marker
>cAppImage = GETPICT("BMP","Select a Picture")
>APPEND GENERAL BM_Picloc FROM (cAppImage) CLASS PBRUSH
>thisform.text45.SetFocus
>THISFORM.Refresh
>*****************************************************
>
>The bmp file is appended to the general field with the Picture and File Name.
>I only want the picture append to general field. How can I do this?
>
>
>
>Thank You In Advance
>
>
>
>Winfred Majors
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform