Hi,
is it possible to manually set order by which navigator reads records in dataset. Currently it reads records according to position in dataset, but I would like to have reverse order.
For example if dataset holds values 1,2,3 (in that order) navigator works ok. But if dataset holds values 3,2,1 navigator doesn't work as expected, meaning that button next moves to prior record (if value is 3, click on next will move to 2)
I know custom events can be set for button clicks, so for example if button next is clicked code dataset.prior can be executed, but the problem is that buttons are automatically grayed when on the last/first position. So if in reverse order dataset position is on record 3 only "Last" button is active instead of "First".
Regards,
Tomaž