EULANDA® ERP System Head Start thru Technology

SET Settings (SQL API)

Back | Level back

The use of the EULANDA®-API requires the set of various SQL-SET-Settings. Without these settings it could come during the command execution to inadvertent errors.

SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON

EULANDA® uses the possibility with Microsoft SQL server computed columns to indicate. These special indices requires the settings specified above not only with put on the index but also with all operations, which the indicated field directly ( INSERT UPDATE) or indirectly (over inserted Stored Procedures) change.

The error message in the case of errors of the settings arises is called e.g.:

Server: Nachr.-Nr. 1934, Severity level 16, Status 1, Line 1
Error with UPDATE, because the following SET options exhibit wrong settings: 'ARITHABORT'.

For no inadvertent errors in the future you should always implement a connection to the SQL server before manufacturing the SET instructions. Also before producing or changing of  stored procedures, triggers etc. must these settings active. If you use the EULANDA®-SQL-Designer happen this easily add.

If you work with other tools like Microsoft Query Analyzer you would measure it for the settings ensure.

For example:

SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE cn_userXXX
/* usw. */

Stored Procedures already existing must be amended over the ALTER command accordingly.

You get the current stored SET option over:

DBCC USEROPTIONS

keywords: CREATE INDEX on computed columns,  ALTER TABLE,

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.