Hi Swen ---

I've had that happen to me before when using the View Designer to create a remote view from SQL Server. A solution is to use DBSETPROP() to change the datatype to Character as such:

OPEN DATABASE mydatabase
=DBSETPROP(remoteview.fieldname,"FIELD","DataType","C(80)")
CLOSE DATA

>Hi... VFP 5.0 SP3 SQL6.5
>I have a remote view pointing to a SQL6.5 table. The SQL table has a field defined as varchar(80). In my VFP5.0 view it appears as a memo. I scatter the memo field. Modify it. Then do an UPDATE on the view. I get the error:
> Connectivity error:.....Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use the CONVERT function to run this query.
>
>I get this error when I try to move off that row in the view.
>
>SO... How do I update a varchar type field on a SQL table?
>
>Thanks
>-swen
>SNielsen@ssd.com