'Order by RecID'

Tue Jun 1 14:10:10 CDT 2004

At 14:09 01.06.2004, you wrote:
>Why the sorting does not work with RecID ?
>(eg SELECT * FROM table ORDER BY RecID)

Hi Olivier,

if no sort order is given, the table is automatically
sorted by RecID ASC. Unfortunately, there seems
to be a bug when adding the "ORDER BY RecID",
but provided you need your records sorted in an
ascending order, you can just leave out the "ORDER BY"
clause.

Martin.

Martin Kloss

Need music? http://www.selling-sound.com

Like the author? Buy the book at:
http://www.amazon.de/exec/obidos/ASIN/3898422194/lingmmugd

Get your daily dose of Lingo at the LingoPark:
http://www.lingopark.de