>
> Yes, you can use the results of virtual fields in other virtual fields. You
> may just call getSubTotal() directly though.
>
> > What is the correct way to handle this?
>
> Be aware that the virtual fields will calc every time the grid asks for a
> refresh.
>
> Paul
This is what I ended doing (thanks to Larry's help). I'm not sure this is the
correct way to handle the problem. But I knew I wanted to keep everything in
the bizobj (don't want violate one of Ed's rules - don't mix UI and Bizobjs).
But I am concerned that the order of the calls is important and maybe timing.
Although, I have not seen any issues. If anyone see anything negative about
my way - Please let me know.
I added two attributes for the child bizobj (_totalrec, _balance). I then
used one virtual field and one method to set the values correctly.
In the child table that contains all of my recieved payments. I did the
following:
def InitProperties(self):
self._totalrec = 0
self._balance = 0
def gettotalRec(self):
tempCur = self.getTempCursor()
tempCur.execute("Select sum(amt_rec) as totalrec from escoursepayments
where fk_enroll = %s" % self.MainForm.esenroll.Record.pkid)
try:
myret = tempCur.Record.totalrec
self._totalrec = myret
self._balance = self.Parent.Record.course_cost - myret
except:
myret = 0
self._totalrec = myret
self._balance = self.Parent.Record.course_cost
return myret
def getBalance(self):
try:
myret = self._balance
except:
myret = 0
return myret
On the Form I have the following:
hs.append(dabo.ui.dLabel(self,Caption='Total Rec'), halign="right")
hs.append(dabo.ui.dTextBox(self,Width=175,ReadOnly=True,RegID='courseRecID',DataSource='public.escoursepayments',DataField='totalrec'))
hs.append(dabo.ui.dLabel(self,Caption='Balance'), halign="right")
hs.append(dabo.ui.dTextBox(self,Width=175,ReadOnly=True,RegID='balanceID',DataSource=self.Form.escoursepayments,
DataField='getBalance'))
The first DataField (totalrec) uses the virtual field. And the second field
uses a DataSource method (getBalance) to retrieve the data.
--
John Fabiani
_______________________________________________
Post Messages to: Dabo-users@leafe.com
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/200905200936.57771.jfabi...@yolo.com
