Problem with pictures displayed in common fields

lancelot0229

There is a student table, which has the field "photo", add a photo with the following statement
APPEND GENERAL photo FROM a.jpg

The issue is:
    When displayed in the form, only the file name a.jpg is displayed, why not display the picture? How can I display the picture?
    Thanks a lot! !

dream88

APPEND GENERAL photo FROM a.jpg----
What database syntax?

170385215

Change to BMP picture

lancelot0229

Remember to create a reg file to solve this problem. The content of the reg file is as follows:

[HKEY_CLASSES_ROOT\.bmp]
@="Paint.Picture"

[HKEY_CLASSES_ROOT\.jpeg]
@="Paint.Picture"

[HKEY_CLASSES_ROOT\.gif]
@="Paint.Picture"

[HKEY_CLASSES_ROOT\.jpg]
@="Paint.Picture"


But I created this file, and the registration still can’t be opened. I don’t know who has a better way

kriesscoen

Normally, DblClick should be able to open.

I remember that the developers of Ken and SQL told me that general pictures, etc., should be saved in files as much as possible.
Only one path needs to be saved in the database, so there may be little or no support for common fields in the future.
Therefore, I do not recommend the above method.

If your pictures are not very big, they should be saved in the following types Memo (Binaray)
Use FileToStr to get a string, and then directly insert it into the type. You can use the field
The content is assigned to the PictureVal property of Image.

lancelot0229

It has been successfully resolved, thank you all
I used the memo field, implemented by the strtofie functions of FILETOSTR