Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert VFP Memo field to SQL Server Image Field
Message
From
12/07/2006 12:15:26
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
 
To
11/07/2006 15:24:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01135374
Message ID:
01135748
Views:
12
Ok I was able to insert into the sql Image field by using XMLTOCURSOR() to get the data. The I used CREATEBINARY() IN THE SQLEXEC() TO INSERT the memo field from the cursor into the SQL Server Image field. The SQLEXEC() did not return any errors. I now have the SQL Image field defined as 'G' general type field in the vfp cursoradapter. I then put an oleboundcontrol on one of my data entry forms and when I try to load it and view the form I get an error "Ole object is invalid or corrupt". Does anyone have any ideas on what I am doing wrong ?

Thanks For Your Help
Stephen J. Hunt
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform