.NET on_error

we are executing some sql string from .NET against sqlanywhere and our errors are not getting reported.
For example. If I have select * from TableThatExists
and then inside the same sql do a select * from TableThatDoesNotExist I don't get any error.
I just receive the first select.
I know the onerror = 'stop' should help but I can't flip that flag since others are using the same database.
I did try to use SET TEMPORARY OPTION ON_ERROR = 'STOP' but that gives an error of "Cannot set a temporary option for user..."

.net

This question is marked "community wiki".

asked 09 Oct '11, 23:28

goroth
6●1●1●4
accept rate: 0%

flat view

2 Answers:

active answers oldest answers newest answers popular answers

AFAIK, on_error is an ISQL option and as such does not have any influence on other applications (like your .Net app).

How are you handling errors around your SQL code? I would expect a query against a non-existing table to throw a SAException object...

permanent link

answered 10 Oct '11, 03:24

Volker Barth
40.2k●361●550●822
accept rate: 34%

edited 10 Oct '11, 03:24

The problem was not SQL Anywhere it was my coding of .NET I was using the DataAdapter.FillSchema against 2 select statements and the FillSchema seems to ingore the table half of the select when getting the column names.

(11 Oct '11, 08:55) goroth

flat view

Please provide your select statement, as Volker says you should get an Exception in .net, e.g. for a statement of the form: select * from ExistingTable where x in (select x from NotExisting) something like:

ERROR [42S02] [Sybase][ODBC Driver][SQL Anywhere]Table 'NotExisting' not found

permanent link

answered 10 Oct '11, 04:24

Martin
9.0k●130●169●257
accept rate: 14%

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

.net ×76

question asked: 09 Oct '11, 23:28

question was seen: 1,707 times

last updated: 11 Oct '11, 08:55

SAP SQL Anywhere

.NET on_error

Follow this question

Related questions