[DB-SIG] Positioned Update/Delete

adustman@comstar.net adustman@comstar.net
Thu, 23 Apr 1998 09:26:41 -0400 (EDT)


On Thu, 23 Apr 1998, Dr. Dieter Maurer wrote:

> How should positioned update/delete be best used with the DB-API:
> 
>  1. cursor.execute("update set ... where CURRENT")
>  2. cursor.execute("update set ... where CURRENT of SELF")
>  3. cursor.execute("update set ... where CURRENT of %s" % str(cursor))
>  4. cursor.execute("update set ... where CURRENT of ?",(cursor,))

4a. cursor.execute("update TABLE set CURRENT = ?", (current,))

Assuming you are using an SQL-89 or so database; the API doesn't really
specify the query language syntax. 

-- 
Andy Dustman                                 WW           Charles Babbage:
ComStar Communications Corp.                 BB       He never used Linux,
(770) 333-8779 | PGP KeyID=0xC72F3F1D        D?        and now, he's dead.