Zeos append/post and re-ordering

[gto]

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

[btrewern]

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

[gto]

Works like a charm
thanks!!