Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL server 6.5 update TEXT field
Message
From
09/02/2000 02:58:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL server 6.5 update TEXT field
Miscellaneous
Thread ID:
00329303
Message ID:
00329303
Views:
65
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