>From: Martijn Tonies [mailto:m.tonies@stripped]
>Sent: Thursday, July 31, 2008 10:37 AM
>Subject: Re: Re-arranging fields
>> >> [JS] I added a dozen or so columns for a special purpose, and
>> >> doesn't care I wanted them in a certain order that would be
>> >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,
>> name all of our fields x1, x2, x3 ....
>There's actually companies that do -almost- just that.
[JS] I've had to work with programs written like that, and cursed the
original author most soundly. Personally, I don't mind the extra typing to
give things suggestive names. It's been a very long time since I had to
worry about the size of a symbol table.
>Either way, the -order- has nothing to do with readable names. If you
>on fields, can't you order the list to filter on? Or do you simply fetch
>the db and that's that?
[JS] Typically I just have them link to the table and "filter by form". Then
they usually copy and paste into an Excel spreadsheet.
>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
>MS SQL Server
>Database development questions? Check the forum!
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1