On May 20, 2010, at 7:56 PM, Carey Gagnon wrote:
> The only issue now is, how do I do joins in sqlite as I have in my bizobjs
> file so that I can use customer.name (customer table) and
> project.name(project table) instead of just the customerID and
> projectID that are
> available in the records table.
Dunno the answer to that, but before you go set up something new, do
you know that data sets understand SQL?
http://wiki.dabodev.com/DataSet
So if you have the records you want in a bizobj, you could do:
ds = biz.getDataSet()
sumDS = ds.execute("select sum(duration) as total from dataset")
totalDuration = sumDS[0]["total"]
Just another idea, in case it makes things simpler for you.
-- Ed Leafe
_______________________________________________
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/[email protected]
