ALTER TABLE ORDER BY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt W - 29 Jun 2004 00:51 GMT

Can anyone possibly tell me why this would not work:

ALTER TABLE PARENTS ORDER BY PARENT;

With of course PARENTS being table and PARENT being field.

Am I seeing something wrong.

Reply to this Message

John Vinson - 29 Jun 2004 01:35 GMT

>Can anyone possibly tell me why this would not work:
>
[quoted text clipped - 3 lines]
>
>Am I seeing something wrong.

Yes. You're assuming that tables have order. They don't.

Use a Query rather than a table datasheet if you want to see records
in a particular order.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message