Dabo-users:
We're building a form that's very similar to the tabbed forms created by
the Appwizard, using the Class Designer. We have a 'Select' tab and a
browse tab with a parent and a child grid.
As in the appwiz, the select tab should construct a new "where" clause from
the selections the user makes, requery the database using the new SQL, and
then set the focus to the browse tab.
Some questions:
1) Can you point us to the place in the appwizard-generated code where the
work of the requery takes place(building the clause and executing the sql)?
I know it's probably right in front of me, but I can't see it!
2)How do you shift focus from one page on a pageframe to another? (Using
the setFocus on a grid on the other page doesn't seem to be working.)
3) Our attempt to get this to work is below (bypassing the construction of
the where clause, we're just changing the query to something that should
get a subset).
bizRuns = self.Form.getBizobj("runs")
bizRuns.addWhere("run_tech = 'RUBIN'")
dabo.ui.info(bizRuns.getSQL(),title="SQL")
bizRuns.setSQL()
self.Form.requery()
The getSQL returns the query with the new where clause, but the requery
gets the original dataset, ignoring the new where clause.
What should we be doing?
Thanks,
Jonathan Poor
Rubin & Poor, Inc.
--- 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]