Ed, Thanks! That did the trick. Is this a "ticket-able" issue? Larry
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Wednesday, September 05, 2007 6:57 PM To: Dabo Users list Subject: Re: [dabo-users] Executing a pass-through 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 [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/!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAafA2fnYuPUOMNFpIYnBEQcKAAAAQAAAA5iTf/[EMAIL PROTECTED]
