>I want to use the sql statment and create a cursor or a view but what if my bufferoveridemode property (=Cursorgetprop()) > 1 than I can't derive the records which are in the buffer mode.., Is there any soln. to derive the records using sql statment even if the buffermode is > 1
>
>TIA
>Regds
>Raj

Raj, are you trying to include in your cursor records that have been changed (or added to) the Table's buffer before you issue a TableUpdate? This is not directly possible, since the SQL-Select always looks to the values of the base table.

If it is important for a user to see data including changed/added data which is in the buffer you will have to get your cursor from the base table and then update it according to the changed/added records in the buffer.

HTH
Barbara