On Nov 8, 2007, at 10:45 AM, Heling Yao wrote:
> I find a few more bugs and some questions with appwizard (0.8.2 win):
Great! Thanks for taking the time to report them.
> Bugs:
> 1. when reportlib is not installed, click on the report generation
> menu items would cause generated app to crash.
Does it crash, or simply exit? I know that there is code in the
loading of the ReportLab stuff that checks if the module is
available, and if it isn't, print a message to the console and exit.
> 2. on the generated app, custom sql doesn't seem to work at all, or
> I'm just missing something obvious?
When you say it doesn't work at all, what's happening? Does clicking
the checkbox do nothing, or does the dialog appear? If it does
appear, are you able to edit the code?
Also, the implementation of the custom SQL is a real hack that was
thrown together to make it available. I mean, clicking a checkbox
brings up a dialog?? ;-)
> Question/Enhancement:
> 1. is it possible to change field names (eg. cust_id to "Customer ID:
> " during the app generation process in batch mode instead of modifying
> the generated ui files one by one?
That will likely be the case when the next version of the AppWizard
is created, which will give you the option of generating .cdxml files
that can later be modified with the visual tools. We already have the
code to do what you suggest in the Class Designer, so it shouldn't be
too hard to use that code in a re-written AppWizard.
> 2. I generated an app using the webtest.sqlite db, now how do I query
> multiple tables? say I'd like to query the total amount of each order,
> which means I need to join order table and orderitems table. If this
> can easily be done, it would be good enough for me to drop MS Access.
Do you have bizobjs defined for those tables? If so, it is
straightforward to just add those bizobjs as children of the customer
bizobj, so that they are automatically requeried with the current
customer PK. You can then add a method in your orders bizobj to
return the sum of all the orditems related to it, and then call the
bizobj.scan() method to total all the orders for that customer. I can
certainly help you with setting this up if my explanation sounds too
confusing.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.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]