Set ORDER BY property for a table

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
 
Yup... it's called a Query :-p

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)
 
Back
Top