>>>>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 ..."
>
Was one of my suggestions as well, but has the problem of resetting with each used index, if they are really needed. Otherwise adding Order By to the .SelectCmd and using the Recno() of the Cursor with no index is clearer IMO.