Re: Primary Key Violation Checking

Rich Shepard <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
On Sun, 28 Oct 2007, Adrian Klaver wrote:

> Are you talking INSERT or UPDATE?  The part about checking the existing
> row would seem to imply an UPDATE.

Adrian,

   I'm adding new rows so I'm using INSERT. When data are edited I use INSERT
OR UPDATE. Should I use the latter in all cases?

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |         Accelerators(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.