>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

Simplest solution I would suggest is to recreate the view.