Re: After updating dataset the record goes to the end of thedataset

Probably what you mean is that you want the order in which the records were

originally inserted into the database. In that case add a serial to your table and

fetch the records like

SELECT * FROM tbl WHERE 1=1 ORDER BY [myserialfield]

It's not foolproof but will in many cases come close to what you seem to be trying

to achieve by not using 'order by'.

Nacef LABIDI wrote:
> Yes I don't issue any sort statement, and I indeed want the data to be show
> as it is stored in the database.