Set ORDER BY property for a table

[Manuel]

I'd like to be able to set the "Order By" property for a table
programmatically. Any ideas as to how I would accomplish this?

Thanks,

Manuel

 

[Jack Leach]

Yup... it's called a Query

Tables don't really have an Order By. Sure, when opening a table you can
set the order on a certain field, but as far as programming goes, you need a
query. It's easy enough, just pull all of your fields in and set the sort
order (and you can take a look at the SQL view to see how to reproduce it via
code).

As a rule though, tables are not sorted, they are merely containers.

hth

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)