Recordset order

[RobJDB]

I want to open a recordset with ADO. I want to order it by the primary key (called "ID" in this case). Trouble is, another field in the table is indexed, so my rs comes in in a weird order. How can I ignore the index and just order my rs by the ID field?

Cheers,
Rob

 

[Bastien]

select * from table
ORDER BY id

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[RobJDB]

Thanks Bastien. I knew about ORDER BY, but something else is going wrong. Looking more closely, it seems my recordset is actually in the correct order, but as I copy its records one by one into a new table, they go out of order in the new table. Could this be because the new table has no primary key defined?
If so, then how do I define a primary key for a new table?

Thanks