2007/11/9, Ed Leafe <[EMAIL PROTECTED]>:
> On Nov 8, 2007, at 10:45 AM, Heling Yao wrote:
> > 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.
Yeah you're right. The program just exits. I was running the app by
clicking it and couldn't see the message. Maybe an info dialog showing
the same message, and then let the user continue to use the generated
app. Just a thought.
>
> > 2. on the generated app, custom sql doesn't seem to work at all, or
> > I'm just missing something obvious?
> 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?? ;-)
My bad. It does work to a certain degree. But say when I select only a
few fields from the customer table, the edit pane becomes all messed
up: db navigation buttons stop working and it's stuck at the first
record; the cmd window keeps giving something like the following:
Traceback (most recent call last):
File "c:\python25\lib\site-packages\Dabo-0.8.2-py2.5.egg\dabo\ui\uiwx\dGrid.py
", line 334, in GetValue
ret = bizobj.getFieldVal(field, row)
File "C:\Python25\lib\site-packages\dabo-0.8.2-py2.5.egg\dabo\biz\dBizobj.py",
line 1314, in getFieldVal
return cursor.getFieldVal(fld, row)
File "C:\Python25\lib\site-packages\dabo-0.8.2-py2.5.egg\dabo\db\dCursorMixin.
py", line 819, in getFieldVal
_("Field"), fld, _("does not exist in the data set"))
dabo.dException.FieldNotFoundException: Field 'title' does not exist in the data
set
>
> > Question/Enhancement:
> > 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.
I do need more guidance with the bizobj part. Never touched that
before. Could you give me a simple example, and maybe some pointers.
I'll go and listen to your bizobj screencast now.
Thanks,
Heling
_______________________________________________
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]
