General information
Title:
SQL server 6.5 update TEXT field
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
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