Maybe, just maybe, becuase I never tryed this:

this.UpdatableFieldList =[....,Level,.....]
this.UpdateNameList     = [...., Level MYDB.TEMPX."LEVEL$",....]

>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 ...
>>