I've recently realized the advantages of doing ad hoc queries using the
getTempCursor method. This is working very well for simple things, but I'm
wondering if it's possible to do something similar to get at child Bizobjs.
For example, my form has a "Sections" Bizobj. "Sections" has a child
"bizDance". I want to get the dance IDs linked to a given section ID. My
current function is as follows. How could I rewrite this so that I don't
wipe out the currently selected dataset for the Sections Bizobj?
biz = self.getBizobj("Sections")
biz.UserSQL = "select * from Sections where ID=%s" %key
biz.requery()
biz2 = biz.bizDance
ks = []
for rownum in biz2.bizIterator():
ks.append(biz2.Record.danceID)
return(ks)
Thanks,
Bronwyn
--- 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]
