Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!elroy.jpl.nasa.gov!decwrl!pa.dec.com!hollie.rdg.dec.com!decuk.uvo.dec.com!nntpd.lkg.dec.com!refine.enet.dec.com!saunders
From: saunders@refine.enet.dec.com (Kyle Saunders)
Newsgroups: comp.databases
Subject: how to implement cursor based UPDATE/DELETE
Message-ID: <22626@shlump.lkg.dec.com>
Date: 13 May 91 13:32:07 GMT
Sender: newsdaemon@shlump.lkg.dec.com
Organization: Digital Equipment Corporation
Lines: 15


	Hi folks,

	I was wondering how you would implement cursor based UPDATE's and 
DELETE's.

	I have given some thought to this and I cannot see how the RDBMS can
properly update the correct row given the fact that the table to be updated
may not have _any_ indexes, and not all fields are guarenteed to be included
in the query.  This means there is no way to uniquely determine which row in
the original base table is being updated.

	- Kyle

	saunders@refine.enet.dec.com