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