Carey, I hate to butt-in here but why not just put all those computed fields in a table VIEW in the database itself and let the db just present the rows to Dabo as if they really were in the table?
IE: Create VIEW xyz as SELECT col1, col2, col3, col1/col2 as col4, col1*col3 as col5 from table xy where ... On Thu, May 20, 2010 at 10:19 AM, Carey Gagnon <[email protected]>wrote: > > > Will return the following tuple of dictionaries: > > > ('{"firstname":"Tom", "lastname":"Dick", "age":"54"}', > > > '{"firstname":"Harry", "lastname":"Tom", "age":"32"}', > > > '{"firstname":"Dick", "lastname":"Harry", "age":"23"}') > > > > > > > > > Do I understand correctly? > > > > Because you are a newbie - I'd like to add that the above assumes that > you > > have issued a 'requery()' for the table or form, and the table is defined > > as > > a bizobject. In other words just coding a "getDataSet()" will not > > retrieved > > data without you coding a few other things. > > > > In general > > 1. define the bizobject > > 2. request data by requery() - this is the SQL statement > > 3.getDataSet() > > > > Johnf > > > > Thanks John and Ed. > > I'm not a complete noob. I have a most of the program I want running, but I > have just hacked this together. I've hit a brick wall so I though it was > time to actually learn what I'm doing with python. > > The brick wall I hit is this: > > I have a database with different customers, projects, and tasks, with start > times and end times. I have created a virtual field to get the duration of > those tasks. Works great to here. > > The brick wall?? > > Now I want to take that duration virtual field and create another virtual > field that will calculate the total time for the project. > > Any who. > > Thanks for the info. I have more reading to do. Gotta learn how to take the > dataset (tuple of dicts) pull duration out on a per projectID bases and sum > them up. > > Thanks Again > > PS: Why are some ppl so long winded ;^) > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > _______________________________________________ > 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] > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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]
