>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
Stephen,
Select * from myTable into cursor crsTransfer readwrite
update mytable set myMemo = "0x"+strconv(myMemo,15)
SQLExec(m.nHandle,"insert into myMSSQL (field1,field2,imageField) values "+;
"(?myTable.field1,?myTable.field2,?myTable.myMemo)")
is one way to do it.
Cetin