Up Prev Next
From: "Peter Collard" <collardp at rabo-bank dot com>
Subject: RE: Error when checking "if exists"
Date: Jun 1 1998 10:27AM
Its much faster to do an insert, and trap the error return. If the row exists then do an update. Alternatively if you expect the row to be there more frequently than not, do the update first, and insert on fail.
Sybase Database Administrator
"The views expressed in this correspondence are mine and not necessarily those of Rabobank International"
From: Rashmi Anand [SMTP:firstname.lastname@example.org]
Sent: Monday, June 01, 1998 10:55 AM
To: SybPerl Discussion List
Subject: Error when checking "if exists"
I am trying to check for the existance of a row and if it exists, send
an update otherwise, send an Insert statement:
if exists (select * from ... where ...)
Update ... where ...
and I get the following error:
DB-Library error: Attempt to initiate a new SQL Server operation with
I don't think the above SQL is returning any results, and I am not
expecting any, then why is dblib throwing the above error?
Any help will be appreciated.
Thanks in advance
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com