Re: Insert into and Sequence

<blockquote cite="mid:4766CE38.6060904@gmail.com" type="cite"><tt><br /> Apparently, new records are not inserted in
thetable according to the order selected by "Test_Step_Id" field; <br /></tt></blockquote><tt>As seen in: <a
class="moz-txt-link-freetext"href="http://en.wikipedia.org/wiki/SQL:">http://en.wikipedia.org/wiki/SQL:</a><br /> "The
orderof rows returned by an SQL query is never guaranteed unless an <code>ORDER BY</code> clause is specified".<br
/><br/> In other words, a database system does not guarantee you the order in which table rows are stored. So, the
orderin which you insert your rows is not the one which has to be followed when selecting them afterwards. You must
specifyby "ORDER BY" how you want to sort your recordset.<br /><br /> It seems you need to revisit the concept of your
system.<br/><br /> Best regards<br /><br /> Irek<br /></tt><br />