Environment versions
Network:
Windows 2008 Server
>>>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.
Why would adding a calculated field to the cursoradatper SQL Select waste DB space ?
But if the cursor needs indeces, do you plan to update the recnum field on each setting order differently ?
Could you use an Order by in the cursoradapter Select and stay with the recnum of the cursor ?
(Usually your questions draw a clear picture for me, on this one I get a "not enough info" warning)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only