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