Okay. This is how the DBSETPROP()s are done and these work. How are these settings done in the CursorAdapter class?

cSql = [select Tempx.PKFLD, Tempx."LEVEL$" as "LEVEL" from MYDB.Tempx Tempx]
create sql view "rv_tempx" remote connection "MyConn" as &cSql

*... other codes
dbsetprop("rv_tempx.level","Field","DataType","C(10)")
dbsetprop("rv_tempx.level","Field","UpdateName","MYDB.TEMPX."+chr(34)+"LEVEL$"+chr(34))
dbsetprop("rv_tempx.level","Field","KeyField",.f.)
dbsetprop("rv_tempx.level","Field","Updatable",.t.)

>Hi all,
>
>I am using the CursorAdapter class in VFP8 and I have this scenario. Due to reserved keyword restriction and poor choice of column names, we have the following table schemas:
>

>
>  Assume that PKFLD is the primary key.
>
>  Oracle:
>  MyTable (PKFLD NUMBER(10), Level$ VARCHAR2(10))  && LEVEL is reserved in Oracle
>
>  VFP8:
>  MyTable (PKFLD I, Level C(10)) && '$' is not valid in VFP8
>
>

>There is the CursorSchema property which I can use for the VFP8 cursor schema. Where should the mapping go?
>
>Using the CREATE SQL format this works:
>

>cSql=[SELECT Level$ AS "Level" FROM MyTable]
>CREATE SQL VIEW rv_MyTable REMOTE CONN MyConn AS &cSql
>* --- DBSETPROP() and CURSORSETPROP() follows ...
>