Hi,
Paul and Ed- thank you again. I must say that I appreciate your offer to code
this for me, and I would like to be able to agree. Unfortunately this project
is reminiscent of the chicken and the egg- I won't have a significant budget
to pay for programmers until the project has results; I won't have results
until I have a completed program.
However, I'm encouraged and I will persevere.
Paul- many thanks for your code- it's gives me a clear idea of how to over-ride
the edit pages. I assume I can do something similar for the search page, and
that joining tables is just a matter of over-riding the sql code (however- how
would I display such results- as they couldn't be edited?).
I've used AppWizardX and I can see much more clearly how every thing fits
together.
However, the following error occurs (both using your MySQL database for the
Orders table, and your Firebird database for the Customers table):
Traceback (most recent call last) [mysql orders]:
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\eventMixin.p
y", line 88, in raiseEvent
bindingFunction(event)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Page
.py", line 317, in onRequery
self.requery()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Page
.py", line 339, in requery
ret = frm.requery()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Form
.py", line 105, in requery
return super(Form, self).requery(dataSource)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dForm.py
", line 348, in requery
response = dProgressDialog.displayAfterWait(self, 2, bizobj.requery)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dProgres
sDialog.py", line 118, in displayAfterWait
tm = dProgressTimer(parentWindow, func, seconds)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dProgres
sDialog.py", line 94, in __init__
func()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\biz\dBizobj.py",
line 629, in requery
self._CurrentCursor.requery(params)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\db\dCursorMixin.
py", line 232, in requery
self.execute(self.CurrentSQL, params)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\db\dCursorMixin.
py", line 207, in execute
row[fld]= unicode(val, self.Encoding)
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 5-7: invalid dat
a
Traceback (most recent call last) [firebird customers]:
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\eventMixin.p
y", line 88, in raiseEvent
bindingFunction(event)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Page
.py", line 317, in onRequery
self.requery()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Page
.py", line 339, in requery
ret = frm.requery()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\lib\datanav\Form
.py", line 105, in requery
return super(Form, self).requery(dataSource)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dForm.py
", line 348, in requery
response = dProgressDialog.displayAfterWait(self, 2, bizobj.requery)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dProgres
sDialog.py", line 118, in displayAfterWait
tm = dProgressTimer(parentWindow, func, seconds)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\ui\uiwx\dProgres
sDialog.py", line 94, in __init__
func()
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\biz\dBizobj.py",
line 629, in requery
self._CurrentCursor.requery(params)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\db\dCursorMixin.
py", line 232, in requery
self.execute(self.CurrentSQL, params)
File "c:\Python24\Lib\site-packages\Dabo-0.4.2-py2.4.egg\dabo\db\dCursorMixin.
py", line 194, in execute
dic[fldNames[i]] = unicode(row[i], self.Encoding)
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 22-25: invalid d
ata
Many thanks.
Matthew Fairclough.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
