You must use Cusor Adapter and mapping fields.
MartinJ
>In regards to how in VFP 8.0 when you issue a SQLEXEC() to create a cursor from a SQL table, all nvarchar type fields translate to VFP as memo fields with unicode. I know of two ways around the unicode, one by using a CAST in the SQL statement, the other using STRTRAN() on the memo field in the VFP cursor.
>
>My question is this, is there some sort of global setting or anything that can be used to avoid either of those two solutions and have the nvarchar types come over to foxpro without the unicode? We have many, many SQL statements and we would like to not have to edit all that code if there is a global setting that can be done.
>
>Thanks in advance,
>
>Mike