>Hi,
>
>With help from the programmer from 10 years ago (nice guy) this is the code that saves the data:
>
>create cursor tmpfile (psig g)
>
>append general psig from (thisformset.tmpname +'_signature.bmp')
>text to csql textmerge noshow
>update tablename set psignature = ?tmpfile.psig where pkid = varNane
>
>So it goes from a temporary file bmp, to a cursor general and then from the general field to a ms sql image field.
>
>Anyone have any thoughts on how to convert back to BMP.
>
>Johnf
Check this page
http://www.sqlusa.com/bestpractices/imageimportexport/
If it's not broken, fix it until it is.
My Blog