-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ed Leafe
Sent: 10. juni 2006 18:24
To: Dabo Users list
Subject: Re: [dabo-users] biz objects, relations and grids
Normally you'd want to create a business object for each table,
but
in this case you simply want to denormalize the type table to get the
type name, right?
I haven't played with this much, but I know Paul has. In this
case,
you can create a single bizobj for the main table, and define its SQL
like this:
biz.addField("main.f1")
biz.addField("main.f2")
biz.addField("main.f3")
biz.addField("child.fname")
biz.setFrom("main join child on main.childFK = child.pk")
In other words, define the fields you want returned, and then
define
the join in the FROM clause. Try that out and let me know how it works.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
This is what I'm looking for, yes. I want to be able to show one main
table (and also just update that), but that table should be populated
with values from other tables. I have one table of task types with
names, and a main table using just integer identifiers to link to the
names.
I also want to be able to change the type of task in the main table.
That is - I need to fill a choice list from one table into a column in
the main table - and when I update the table, the integer identifier of
the choice should be saved.
I can also modify the tables if this is difficult to do using dabo.
(I'm no sql expert, so my database design might be a broken design)
Thanks for the help.
-Simen
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
