Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert VFP Memo field to SQL Server Image Field
Message
From
11/07/2006 11:36:19
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Convert VFP Memo field to SQL Server Image Field
Miscellaneous
Thread ID:
01135374
Message ID:
01135374
Views:
127
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
Next
Reply
Map
View

Click here to load this message in the networking platform