<snip>
>
>Second, I just created a new view using a remote connect to a SQL table. After adding this SQL table to the view, I was surprised to see that the view properties had all been automatically set to "CHARACTER" for all of the 'varchar' fields in the SQL table. I was able to change all of the properties from "Character" to 'varchar' and everything then worked as 'advertized' but it seems crazy that you would need to manually reset all of the fields from 'character' to 'varchar.' Does anyone know why the ViewDesigner did not automatically set the properties to 'varchar?'
>
>FYI ... the SET VARCHARMAPPING feature was set to ON.
>

Hi Robert,

SET VARCHARMAPPING controls only SQL Engine behavior. You can issue CURSORSETPROP("MapVarchar",.T.,0) and subsequently View Designer and CREATE/MODIFY VIEW commands will map varchar to varchar .