The primary key is indeed an integer, but it is not set to auto-increment.
Below is the traceback; thanks so much for your help!
Traceback (most recent call last):
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\eventMixin.py",
line 98, in raiseEvent
bindingFunction(event)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\datanav2\Page.py",
line 334, in onRequery
self.requery()
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\datanav2\Page.py",
line 362, in requery
ret = frm.requery(_fromSelectPage=True)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\datanav2\Form.py",
line 483, in requery
return self.super(dataSource)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\autosuper\autosuper.py",
line 176, in __call__
return method(*p, **kw)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\ui\uiwx\dForm.py",
line 431, in requery
if not self.confirmChanges(bizobjs=bizobj):
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\ui\uiwx\dForm.py",
line 184, in confirmChanges
self.save(dataSource=biz.DataSource)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\lib\datanav2\Form.py",
line 53, in save
ret = super(Form, self).save(dataSource)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\ui\uiwx\dForm.py",
line 342, in save
bizobj.saveAll()
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\biz\dBizobj.py",
line 272, in saveAll
startTransaction=False, topLevel=False)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\biz\dBizobj.py",
line 639, in scanChangedRows
func(*args, **kwargs)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\biz\dBizobj.py",
line 325, in save
cursor.save()
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\db\dCursorMixin.py",
line 1066, in save
saverow(self.RowNumber)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\db\dCursorMixin.py",
line 1037, in saverow
self.__saverow(row)
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\db\dCursorMixin.py",
line 1150, in __saverow
self.BackendObject.noResultsOnSave()
File
"C:\Python25\lib\site-packages\dabo-0.8.1s-py2.5.egg\dabo\db\dBackend.py",
line 108, in noResultsOnSave
raise dException.dException, _("No records updated")
dException: No records updated
On Nov 15, 2007 3:57 PM, Paul McNett <[EMAIL PROTECTED]> wrote:
>
> William Bryant wrote:
>
> > Hello all,
> >
> > I've generated a very simple app with the class designer. The app connects
> > to
> > a MySQL database. Queries work fine, editing and deleting records work
> > fine, but new records do not get inserted.
> >
> > I can insert records into the target table with a non-dabo python program.
> >
> > In the dabo app, I'm trying to insert by selecting "New Record" from
> > the "Actions"
> > pulldown, then selecting "Save Changes" from "Actions." A traceback ends
> > with
> > "No records updated" exception raised via self.BackendObject.noResultsOnSave
> > in dCursorMixin.py.
> >
> > I expect I've overlooked something pretty obvious; if so, please treat
> > me gently,
> > and many thanks!
>
> The first thing that comes to my mind is primary-key (pk) related. Is
> the pk on the MySQL side an integer set to auto-increment?
>
> If so, you need one set of property settings on the bizobj, and if not,
> you need another set.
>
> Also, can you please post the entire traceback you are getting?
> Hopefully it'll show a MySQL exception and we can figure out what is
> wrong from that.
>
> --
> pkm ~ http://paulmcnett.com
>
>
[excessive quoting removed by server]
_______________________________________________
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]
