Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Re: After updat...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3426 of 3558
Post > Topic >>

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

by Bart.Degryse@[EMAIL PROTECTED] ("Bart Degryse") Apr 22, 2008 at 02:56 PM

--=__PartBD94F570.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Probably what you mean is that you want the order in which the records =
were=20
originally inserted into the database. In that case add a serial to your =
table and
fetch the records like
SELECT * FROM tbl WHERE 1=3D1 ORDER BY [myserialfield]
It's not foolproof but will in many cases come close to what you seem to =
be trying=20
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.

--=__PartBD94F570.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Probably what you mean is that you want&nbsp;the order in which the =
records were </DIV>
<DIV>originally inserted into the database. In that case add a serial to =
your table and</DIV>
<DIV>fetch the records like</DIV>
<DIV>SELECT * FROM tbl WHERE 1=3D1 ORDER BY [myserialfield]</DIV>
<DIV>It's not foolproof but will in many cases&nbsp;come close
to&nbsp;what=
 you seem to be trying </DIV>
<DIV>to achieve by not using 'order by'.<BR><BR>Nacef LABIDI
wrote:<BR>&gt;=
 Yes I don't issue any sort statement, and I indeed want the data to be =
show<BR>&gt; as it is stored in the database.<BR></DIV></BODY></HTML>

--=__PartBD94F570.1__=--




 1 Posts in Topic:
Re: After updating dataset the record goes to the end of
Bart.Degryse@[EMAIL PROTE  2008-04-22 14:56:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 23:02:03 CDT 2008.