Hi!

I see nobody answer to this thread so far, so I can try to help you if this is needed.

What exactly you do when save image in the general field?

When image was saved using APPEND GENERAL command, I douobt you can do this from VB. THis is because ADO return general field as binary field type, you can get its content using AppendChunk method of that field or just by using saving into the file by ADO Stream object. However, the content of such general field is not the BMP file itself. I know there is a tool that allows to strip out the BMP file from general field content, however I do not remember where I have seen it. try to search for it here, at www.tek-tips.com, ProFox list server archives or ask about this specifically in another thread (like "How to strip out BMP file from the general field content"). However, read before that next paragraph.

Well, you can use another approach to store images in the VFP database. BMP file could be easy and by reliable way stored in the Memo field in VFP table. Take a look to the FileToStr() and StrToFile() functions in the help. They will help you to get file into string and save it in the memo field. As opposite, StrToFile will allow you to write content of memo field into the temporary BMP file to display it in the Image control (in VFP) or in whatever control you want (include in VB).

>Hi everybody, how can I access a .bmp file from a general field using ADO? I need use VB in this case to show the pict in a control. Since now, thank you very much.