Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to read an image from a GENERAL field
Message
De
11/12/2006 09:47:13
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
11/12/2006 09:02:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Divers
Thread ID:
01176470
Message ID:
01176531
Vues:
16
Ken,
G is internally M but what would this help for? How would this strip out OLE header?
Cetin

>You can manually set the field type character in the DBF to be a Memo field
>For this to work, make sure the first field is the General field
>
>Not sure where I found this code, I believe it was here.
>
>There may be more intelligent code out there that parses the whole DBF structure for General fields. Anyway, this worked for me.
>
>select em_photo from mydb where condition into dbf c:\temp.dbf
>
>lnHandle = Fopen(lcfname,12) && open lowlevel to change
>
>Fseek(lnHandle,43,0)
>
>lctype = FREAD(lnhandle, 1)
>IF lctype = 'G'
> Fseek(lnHandle,43,0)
> Fwrite(lnHandle,'M',1) && Changing General to Memo
>ELSE
> ? lctype
> WAIT 'not gen '
> endif
>Fclose(lnHandle)
>
>
>
>>Hey,
>>I want to store the snaps(in JPEG Format) of employee to the database.
>>I use a picture control to show this image on the form.
>>While saving the snaps I can directly save it to the database using...
>>
>>APPEND GENERAL em_photo FROM z:\data\images\ku0001.jpg
>>
>>But while retriving the same, I am not able to do the same.
>>Please suggest me a way out.
>>Thanks in advance.
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform