What is your SQL Server field type (is it a text field or a varchar?)
Is it, for instance, a varchar(255) in SQL Server, that VFP sees as a memo field ?
It can handle a varchar(254) as a character field.

I would say, if the above is the case, avoid varchar(255) and use varchar(254).
varchar(255) is a special case, (or mappings of varchars to memo fields) because I think the ODBC driver assumes a VFP memo field is a text field on SQL Server when it isn't and is using the WRITETEXT functions of SQL Server.


>I change a table in 6.5 and i changed the views in FoxPro to show the new chnages in the table i changed.
>
>I can add records but when i go to edit the record i get this message after a save click.
>
>Implicit Conversion From Datatype "Text" to "VarChar" is not allowed use the convert function to run this query.
>
>I checked all the fields in SQL 6.5 they match the way i created the table.
>
>I checked the view in FoxPro and the files were the same except for the naming of "Text" in SQl is equal to "Memo" in FoxPro.
>
>Can anyone please help
>
>Shawn