>I am trying to Convert a VFP Memo field to a SQL Server Image Field. I am using
>SQLEXEC() in vfp to try to insert the records. I am using XMLTOCURSOR() to get
>the field from an xml file into a cursor, when I do a TYPE() of the field it returns 'M'. I then Issue an insert into with SQLEXEC() into the SQL Server Image field. When I try to view the image field on a crystal report it just shows blank. I do not think that the image is being stored properly, does anyone know anything else I can try to get this to work ?
>
>Thanks For Your Help !
>Stephen J. Hunt
Select * from myTable into cursor crsTransfer readwrite
update crsTransfer set myMemo = "x"+strconv(myMemo,15)
SQLPrepare(m.nHandle,"insert into myMSSQL (field1,field2,imageField) values "+;
"(?crsTransfer.field1,?crsTransfer.field2,'?crsTransfer.myMemo')")
scan
SQLExec(m.nHandle)
endscan
Cetin