On Saturday 16 February 2008 01:43:12 pm Michael Hipp wrote: > How does the UI, bizobj and database layer in Dabo cope with screens, > business rules and database queries that span multiple tables and > records? Can anyone point me to some example code that shows how Dabo > handles this? > > Lots of "models" appear to be somewhat cast in what I call the 1:1:1 > syndrome (i.e. each screen holds one record from one table that is > governed by one set of business logic). > > How do the layers of dabo handle the (frequent) case where one screen > may have fields (hidden or otherwise) that span multiple tables, thereby > spanning multiple sets of business logic and so on. > > ... probably clear as mud ... > > Thanks, > Michael
Right clear as mud! I think what you are saying is how does Dabo deal with one to many data setups. Great! To my knowledge there is no limit on the number of child tables a parent can have. What ever you can setup using SQL I'm sure Dabo can handle. I have several forms that have many children (or a relationship I create using SQL) which means I have many different fields from different tables on my forms. On the same forms I use tables (lookups, meta data, combobox source) that I use to supply the data that are not children of the parent. Hidden fields? I think you mean fields that are not displayed on the screen. All the fields are available that you define. Dabo even has a virtual field that can be defined. Business logic? Do you mean can Dabo validate input - yes. If you mean will Dabo determine some special need (like if I add "A" there has to a "B" and "C" that exist) you most likely will require that you write special code. Of course if you can define it in the database - that's always better. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
