Just had always assumed you could insert a row in the
middle of the dataset. Kind of like altering the table you
can insert a column at a given position.
SQL datasets by definition have no natural order. Therefore, the idea of
inserting into the "middle" or even at the end of a table is meaningless.
Don't count on any SQL database giving you back your data in any particular
order (such as order entered) unless you specifically request that order using
ORDER BY. R:Base _generally_ gives you data back in as-entered order, but not
always. Other systems _never_ give you data back in as-entered order -- they
often default to ordering by primary key value.
--
Larry
