New topic: Any suggestions on strategy to represent field names etc.?
<http://forums.realsoftware.com/viewtopic.php?t=33843> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message basil.bourque Post subject: Any suggestions on strategy to represent field names etc.?Posted: Tue May 18, 2010 5:21 pm Joined: Thu Apr 15, 2010 10:41 pm Posts: 10 Location: Seattle-area I have working code to pull the field names from a RecordSet and display those as column headers in a ListBox. But of course, the names in the SQL table-field definition is not what I want to display to the user in the GUI. Also, I need to track other info, such as which fields should be invisible, and the default order of columns in a ListBox. There must be a more elegant solution than hard-coding this info in the code on ListBoxes and Buttons. Has there been any discussion of ideas or strategies for representing this kind of database meta-data in REALbasic? --Basil Bourque _________________ --Basil Bourque (Using REAL Studio 2010 release 2 with REAL Server 2009r1.2 on Mac OS X 10.6.2 & .3) Top timhare Post subject: Re: Any suggestions on strategy to represent field names etcPosted: Tue May 18, 2010 5:32 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 7779 Location: Portland, OR USA What is inelegant about hand crafting a UI that best presents data to the user and interacts with him in a logical manner? In my opinion, the kind of interface you're describing usually turns out clunky and hard to use. 90% of app development should be engineering the user interface. That's the "hard work" in programming. Sadly, many programmers seem to want to skip that part. Top DaveS Post subject: Re: Any suggestions on strategy to represent field names etcPosted: Tue May 18, 2010 5:38 pm Joined: Sun Aug 05, 2007 10:46 am Posts: 2355 Location: San Diego, CA How about adding a meta-data table to your database? Fields would define your UI, for example you might have tablename fieldname xpos ypos visible etc... Pretty much like the IDE you are using to design screens in RB... at least from the property panel point of view This way you never need to change you "code", just change the data in this table to redefine the UI _________________ Dave Sisemore MacPro, OSX 10.6.2 RB2009r5.1 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
