Cory Cross wrote: > First of all, thank you Paul for this good explanation of derived > fields. If this isn't in the Wiki, I'll update it soon.
That would be great! >> def fillDerivedFields(self): >> cur = self.getTempCursor() >> >> # cust_name, cust_account: >> cur.UserSQL = "select name, account from customers where >> id='%s'" % >> self.Record.cust_id >> cur.requery() > > Is this going to be hitting the database every time the number is > updated on the form? How big of a database have you done this on? Well, it'll hit the database every time you call fillDerivedFields(), yes. I only call fillDerivedFields() in biz.afterSave(), so I don't notice a performance hit. -- pkm ~ http://paulmcnett.com _______________________________________________ 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]
