Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text/varchar
Message
From
16/06/1998 13:18:42
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00108745
Message ID:
00108751
Views:
49
Hi Marcelo...

>I executed a "sqlexec" command to get a table from SQL-Server.
>When I changed the value of a memo field (text in SQL) that have more than 255 chars, and tried to go to another record, it returned this error:
>
>[Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use the CONVERT function to run this query.]
>
>Does someone knows how can I do to fix it ??
>

The source table in SQL Server has that column defined as VARCHAR, which can only be up to 255 characters in length. You either have to limit the amount of entry on the front-end, or ALTER TABLE the SQL Server table and change that column into the TEXT type.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform