Hi,
AppWizardX works well. But not with the Firebird database (a long list of
errors when trying to start the app created).
I have also noticed that the app created does not update the database.
Just noticed that while the errors in my previous post occur, the app still
works. What happens is that after re-querying it remains on the search page.
Also, for AppWizardX, it works for only one table (and fails completely if
relationSpecs are set). What should I do for multiple tables?
> For instance, this line at the end of my FrmClients.afterInit() adds a page
> that
> I've defined to list the client's activity and report their current balance:
>
> self.PageFrame.appendPage(PagClientBalance, "Balance")
I've been trying to simulate this. If I add the following code the app runs,
but I can't see the page:
PageFrame=dabo.ui.dPageFrame(self)
self.dPageFrame.appendPage(self.Application.ui.PagClientBalance,
"Balance")
To get it running I've copied your PagEditClient.py as PagClientBalance.py. What
am I doing wrong?
>
>
> > 2. I need to customise the search page to search on foreign keys with
> > drop down menus. The options in FieldSpecEditor seem limited. How can
> > I add custom fields to configure the search form (and also the entry
> > form) to a greater degree
>
> I'm working on giving user code a hook into the search options, so stay tuned
> on
> that.
In the meantime, how can I over-ride the search page?
As far as the edit page goes, you can override that by changing your
> form
> code (located in ui/Frm*.py, where * is the name of the table) to something
> like
> (my example is with FrmClients):
<Snip>
This worked really well. I've changed it for the Customers table, and added a
drop down just to see how that would work. Seems quite easy.
> > 3. Many of the reports I will need to produce involve joins from
> > several tables. For example, a report of each orditem with the total
> > number of orders. Where would such code go
>
> Multi-table joins aren't a problem, that is a common need. What the runtime
> ReportWriter needs is a single dataset (denormalize your multiple tables into
> one dataset with repeated values in the proper order for consumption by the
> report writer), and a report format xml file (rfxml). The rfxml has sections
> for
<Snip>
Return everything in one dataset. Using your Invoice as an example, each
Invoice would have:
- customer details
- multiple order details
Could this be passed in one dataset? If I was doing this at present with my
web-app, I would just make two sql calls.
Thanks for your patience and help.
Matthew.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
