I am using a cursor which has some backend data in it fetched from a
previous select statement.
Now I want to update an unrelated table directly and thought I could use the
cursor's executeSafe method as shown below...
self.tmpCursor.executeSafe("update public.aginvtrans set ncost=%s*nqty where
fk_agsublot=%s and dtrns<='%s'"%(self.LotCost,npkid,dEffective))
All the variables exist, but when I run it I get...
IndexError: list index out of range
Traceback (innermost last):
File "d:\pyProject\pyProject\LotsMfrm1.py", line 1, in <module>
import time
File "d:\pyProject\pyProject\LotsMfrm1.py", line 931, in <module>
app.start()
File "d:\dabo\dabo\dApp.py", line 296, in start
self.uiApp.start(self)
File "d:\dabo\dabo\ui\uiwx\uiApp.py", line 261, in start
self.MainLoop()
File "c:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py", line
7786, in MainLoop
wx.PyApp.MainLoop(self)
File "c:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py", line
7147, in MainLoop
return _core_.PyApp_MainLoop(*args, **kwargs)
File "d:\dabo\dabo\ui\uiwx\dControlMixin.py", line 21, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File "d:\dabo\dabo\ui\uiwx\dPemMixin.py", line 843, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File "d:\dabo\dabo\lib\eventMixin.py", line 92, in raiseEvent
bindingFunction(event)
File "d:\pyProject\pyProject\RAClasses.py", line 1162, in onSave
self.Form.save()
File "d:\dabo\dabo\ui\uiwx\dForm.py", line 342, in save
bizobj.saveAll()
File "d:\dabo\dabo\biz\dBizobj.py", line 277, in saveAll
startTransaction=False)
File "d:\dabo\dabo\biz\dBizobj.py", line 690, in scanChangedRows
func(*args, **kwargs)
File "d:\dabo\dabo\biz\dBizobj.py", line 345, in save
child.saveAll(startTransaction=False)
File "d:\dabo\dabo\biz\dBizobj.py", line 277, in saveAll
startTransaction=False)
File "d:\dabo\dabo\biz\dBizobj.py", line 690, in scanChangedRows
func(*args, **kwargs)
File "d:\dabo\dabo\biz\dBizobj.py", line 379, in save
self.afterSave()
File "d:\pyProject\pyProject\LotsBizobj.py", line 446, in afterSave
self.scan(self.recalcCosts)
File "d:\dabo\dabo\biz\dBizobj.py", line 608, in scan
self.scanRows(func, range(self.RowCount), *args, **kwargs)
File "d:\dabo\dabo\biz\dBizobj.py", line 646, in scanRows
func(*args, **kwargs)
File "d:\pyProject\pyProject\LotsBizobj.py", line 477, in recalcCosts
self.tmpCursor.executeSafe("update public.aginvtrans set ncost=%s*nqty
where fk_agsublot=%s and dtrns<='%s'"%(self.LotCost,npkid,dEffective))
File "d:\dabo\dabo\db\dCursorMixin.py", line 351, in executeSafe
self._syncAuxProperties()
File "d:\dabo\dabo\db\dCursorMixin.py", line 365, in _syncAuxProperties
ac.DataStructure = self.DataStructure
File "d:\dabo\dabo\db\dCursorMixin.py", line 2086, in _getDataStructure
ds = self.BackendObject.getStructureDescription(self)
File "d:\dabo\dabo\db\dBackend.py", line 460, in getStructureDescription
standard_fields = cursor.getFields()
File "d:\dabo\dabo\db\dCursorMixin.py", line 1676, in getFields
return self.BackendObject.getFields(tableName, self.AuxCursor)
File "d:\dabo\dabo\db\dbPostgreSQL.py", line 84, in getFields
localTableName = tableNameBreak[1]
What am I missing?
Thanks,
Larry Long
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.5/990 - Release Date: 09/04/2007
10:36 PM
_______________________________________________
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]
