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