Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Store Picture in General Field.
Message
De
13/10/2000 16:37:45
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00428754
Message ID:
00429375
Vues:
14
>>>>It is so easy, you'll slap yourself with the trout :)
>>>>
>>>>In the report writer, add a picture field. In properties of the picture, use the FILE entry (not the FIELD entry). In FILE, put the cursor field that holds the full path of the file (eg. tmpCursor.fullFileNameofPictureFile).
>>>
>>>Hej, I made the same, but got error 'invalid file path'.
>>>
>>>>
>>Did you get this error when designing the report, or running the report?
>
>Running on preview. I have some empty fields in table (no picture filepath stored), and what about extra spaces at the end of char fields in VFP?

In my SELECT statment I do something like:
	select s.styleNum, s.description, ;
		...more fields ...,;
		fullPictureFileName(s.picfile) as picFile, ;
                ...more stuff
FullPictureFileName() prepends the full path (stored in application object) to the file name, and does trimming. Also, it makes sure that the file exists. If the field is blank, or if the file does not exist, fullPictureFileName returns oApp.noPictureFileName. In my application object, this is the full file name of a blank JPG file (or it could be a JPG file that has "NO PICTURE" on it).
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform