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

------=_Part_3111_22105555.1208869221994
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 <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.
>

------=_Part_3111_22105555.1208869221994
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thank you all for your useful comments.<br><br>I have tried to order my
records as you said and got it work as I wanted.<br><br>Thank you
again<br><br><div class="gmail_quote">On Tue, Apr 22, 2008 at 2:56 PM,
Bart Degryse &lt;<a
href="mailto:Bart.Degryse@[EMAIL PROTECTED]
">Bart.Degryse@[EMAIL PROTECTED]
>&gt;
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 style="margin: 4px 4px 1px; font-family: Tahoma; font-style: normal;
font-variant: normal; font-weight: normal; font-size: 10pt; line-height:
normal; font-size-adjust: none; font-stretch: normal;">
<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=1 ORDER BY [myserialfield]</div>
<div>It&#39;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 &#39;order by&#39;.<div
class="Ih2E3d"><br><br>Nacef LABIDI wrote:<br>&gt; Yes I don&#39;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></div></div>
</blockquote></div><br>

------=_Part_3111_22105555.1208869221994--