> >> [JS] I added a dozen or so columns for a special purpose, and although
> >> doesn't care I wanted them in a certain order that would be intuitive
> >to a
> >> user / programmer.
> >Why is a user looking at your database?
> >This is a security breach. Users should only have access thru
> >pre-defined SQL statements.
> [JS] Users will have read-only access through MS Access, and have to
> on various fields.
> If we weren't trying to make our database designs somewhat intuitive, we'd
> name all of our fields x1, x2, x3 ....
There's actually companies that do -almost- just that.
Either way, the -order- has nothing to do with readable names. If you filter
on fields, can't you order the list to filter on? Or do you simply fetch
the db and that's that?
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!