Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement