by Ad van der Wer » Thu, 24 Jun 1999 04:00:00
Is it possible to force SET ARITHABORT is OFF for insert, delete or update
statements. I don't want that the query is aborts but that is returns a
NULL-value.
1. Sudden QUOTED_IDENTIFIER / ARITHABORT problem
Hello
I've been writing the same application for almost 2 years no, most of which
has been on SQL 2000. Suddenly, tried and true code is no longer working.
sSQL = "delete from sometable where thedate='1/1/202' "
oCN.Execute sSQL, , adExecuteNoRecords
That now returns an error that the ARITHABORT parameters is wrong. I correct
that, then receive a similar for QUOTED_IDENTIFIER.
Fixed:
oCN.Execute "Set ArithAbort on", , adExecuteNoRecords
oCN.execute "set quoted_identifier on", , adExecuteNoRecords
sSQL = "delete from sometable where thedate='1/1/2002' "
oCN.Execute sSQL, , adExecuteNoRecords
Next, a call to a stored procedure that does an update statement failes due
to QUOTED IDENTIFIER. When you use Query Analyzer to edit a stored
procedure, (right click in object browser, edit), it prefaces procedure with
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
I had to change the first to ON and recompile.
I tried from VB using ADO2.5, 2.6, 2.7. They all do the same thing.
Any idea what changed or how I can fix it? I'd hate to have to recompile
everything.
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.0 (Build 2195: Service Pack 3)
2. What is QBE?
3. ARITHABORT when updating an Indexed View and the Base Tablw
4. non-standard string escaping in other DBs than MySQL?
5. QUOTED_IDENTIFIER and ARITHABORT for Maint jobs
6. a problem with "LIKE" operator
7. Turning off ARITHABORT for a database with SQLDMO
8. pgsql-server/ /Tag: /REL7_3_STABLE /HISTORY oc ...
9. "ARITHABORT"
10. ARITHABORT Error
11. SET ARITHABORT setting in SP