Zeoslib Portal

Hello there!
Is there a way to append a record to an ordered query (something like select * from costumers order by number, where number is also primary key), fill the record with a value that will be in the middle of the result (if you have numbers 1, 2, 4 and 5 already on database, then you post the 3) and expect that this query will be re-ordered, that when users post and click next at the DbNavigator, the next record will be the 4?

Ugh, dunno if it was unclear, ask if it does hehh

thanks

Does this work if you do the ordering in the dataset?

Try setting to SortedFields to the field you want to order by.

Hope this helps.

Regards,

Ben

Works like a charm
thanks!!