>>>Hi,
>>>I need to show "record" counter for the CursorAdapter cursor; for example, "Record 1 of 100."
>>>I cannot use recno() because the cursor is indexed and recno() does not show in a sequential order.
>>>I tried to add a "dummy" column to the CA cursor. But I get message that this operation is not allowed for buffered cursor. When I tried to set the buffering to 1 (using CURSORSETPROP("Buffering", 1, "CA_ALIAS") I get message that "Operation is not allowed for CursorAdapter"
>>>The only option remaining (as far as I can think of) is to add a "dummy" column to the table and use it to assign sequential numbers. Even though the table is not very large, it would waste database space (this is SQL Server database).
>>>Any suggestions on how else I can accomplish this?
>>
>>
>>Instead of CURSORSETPROP("Buffering", 1, "CA_ALIAS") try to use CURSORSETPROP("Buffering", 3, "CA_ALIAS").
>
>Yes, changing from 1 to 3 allows the CURSORSETPROP() to be executed without an error. However, when I do ALTER TABLE ADD COLUMN ... I get error message that "Function is not supported on remote tables." So I am back to considering a "dummy" column.
>Thank you for your help.

Add this field in SelectCmd property of the CA (if you use CursorSchema add it there also) :
Do not add it in Update... lists properties.

this.SelectCmd = "SELECT ...., CAST(0 as int) AS RecNum FROM ..."