Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Could not update remote view on SQL 6.5
Message
From
09/02/2000 11:04:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Could not update remote view on SQL 6.5
Miscellaneous
Thread ID:
00329446
Message ID:
00329446
Views:
55
Hi

I have a question about the SQL server 6.5 and VFP 6.0. On the SQL
server I made the table called TEST, where is one text fields named
TEST.
When I open the remote view from the VFP, append new reccord, replace
the TEST field with some text and update it, everything is OK, but when I open this remote view once again and wants to change the TEST field with the new one, I've got this error message

"[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use the CONVERT function to run this query.".

This problem is only with the SQL 6.5, on the SQL 7.0 is everything
right.
Reply
Map
View

Click here to load this message in the networking platform