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

You are right about the fact that the rows don't keep the order they where created with at the start. I have verfied
this.<br/><br />I will explain more my case :<br /><br />I am writing an application where here is some resources to
planevents on. I want to provide the user with the ability to customize the order in which resources are displayed on
thescreen. So there is a mapping between the rows positions in the dataset and they display positions. After updating
oneof these resources the row jumps to the end of the dataset so does the resource on the display. And the order gets
scrambled.I cannot set this order in the databe since it is customizable for each user.<br /><br />When I have tested
thiswith SQLServer it works well, since the rows doesn't change position on the DB.<br /><br />I hope that you
understandmy issue and I will provide any explanations if someting isn't clear enough.<br /><br />Thanks to all<br
/>Nacef<br/><br /><div class="gmail_quote">On Tue, Apr 22, 2008 at 12:15 PM, hubert depesz lubaczewski <<a
href="mailto:depesz@depesz.com">depesz@depesz.com</a>>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On
Tue,Apr 22, 2008 at 12:10:41PM +0200, Nacef LABIDI wrote:<br /> > Yes I don't issue any sort statement, and I indeed
wantthe data to be show<br /> > as it is stored in the database. But after updating a row (I don't update<br /> >
theID, just some fields), it keeps its same place on the DB but jumps to<br /> > the end of the dataset and by the
wayto the end of the DBGrid.<br /><br /></div>why do you think it stays in the same place in db?<br /><br /> besides -
without"order by" you cannot depend on the order of rows.<br /> basically i treat them as in "random" order (which is
nottrue, but<br /> helps me remember to never count on the "default" ordering.<br /><br /> depesz<br /><font
color="#888888"><br/> --<br /> quicksil1er: "postgres is excellent, but like any DB it requires a<br /> highly paid
DBA. here's my CV!" :)<br /><a href="http://www.depesz.com/" target="_blank">http://www.depesz.com/</a> - blog dla
ciebie(i moje CV)<br /></font></blockquote></div><br />