Thank you all for your useful comments. I have tried to order my records as you said and got it work as I wanted.
Thank you again On Tue, Apr 22, 2008 at 2:56 PM, Bart Degryse <[EMAIL PROTECTED]> wrote: > 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. >