Is it a text or a varchar column in the SQL server table? If it is text, try mapping it to Memo on VFP side, if it's varchar it should map fine to Char.
>I have an application that is using a text field in SQL Server 6.5. When I put this in a remote view and try to modify this text field, the tableupdate returns false. Also, I get an error message saying "Implicit conversion datatype 'text' to datatype 'varchar' is not allowed. Use CONVERT function to run this query."
>Anybody have any suggestion?
------------------------------------------------
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