New topic: Generically populating database fields to window controls
<http://forums.realsoftware.com/viewtopic.php?t=47616> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message superjacent Post subject: Generically populating database fields to window controlsPosted: Wed Apr 17, 2013 3:22 am Joined: Sat Oct 01, 2005 4:47 am Posts: 88 Location: Melbourne, Australia I'm seeking some insight into a project in which I'm attempting to re-write Microsoft Access code. The project involves database activity and will be retaining connection to MS Access mdb's. There are numerous base tables for traditional stuff such as, names, addresses, phones, log entries (these are all tables in their own right) plus a heap of other base tables. Heaps of secondary linking tables (ie. contacts - link - phones etc.) I mention this as there will be lots and lots of separate windows. I'm attempting to be as generic as possible with the process of populating window controls (textfields, checkboxes etc.) with data from the associated SQL statements (recordsets). I've already developed classes to handle the SQL side of things. Here's what I've come up with to date: I'm thinking to sub-class all relevant window controls (textfield, textarea, checkbox etc.), at a minimum add string properties, named, TableName & FieldName. The purpose being that these controls will contain the name of the field from the table. At the class level, cycle through the sub-classed controls, retrieve the value of the field from the table and populate the window control. I'd like to know if I'm on the right track. What other methods or process could be employed to be as generic as possible? _________________ Steve rs2012 r2.1 Windows 7. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- 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]
