Next Question!
What version of SQL Server ODBC driver are you using? I remember having a problem updating text fields that was related to a particular driver version.
The only problem I have ever had is updating a memo field on SQL Server views. That was fixed by creating the remote view directly agains the table.
I also created my largest varchar field of 254, because 255 created a memo field in VFP which wasn't as easy to browse (and what difference will 1 character make?)
Otherwise, updates etc have always been smooth and trouble free. At any rate, the problem should be findable and solveable!
>Bob;
>The remote view in FoxPro is based off of a table in 6.5. I checked the properties on the FoxPro side of things to ensure that the they were the same as the server.
>
>The Server shows the field type as 'Text' and a Size of 16
>In FoxPro for the same field it shows field type of 'Memo' and the width field is grayed out.
>
>I hope this helps
>Shawn
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only