On Sep 5, 2007, at 5:29 PM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
> 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))
It looks like the problem is in the cursor trying to sync its data
structure with the 'temp' cursor in the executeSafe() method. Try
running the AuxCursor directly:
self.tmpCursor.AuxCursor.execute("update...
-- 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]
