Is there way in SQL Anywhere 11.0.1.2324 to switch off the
"result is non-deterministic" message? Perhaps a database
option?

We have a client application that uses Version 7 which
didn’t complain if a sql returned a non-deterministic
record set and would like to avoid rewriting any code.

Unforturnately, it has been this way since the release of 9.0 .

From the very beginning the recommendation has been
to use first and top with an order by clause. Even in the
initial 7.0 doc set the feature was documented as follows:

FIRST or TOP
These keywords are principally for use with ORDER BY queries.

and the wording got stronger in V8.

Adding an order by clause or change the query to use a where
clause that uniquely defines the row in question are the only
options now.


"Phil Harris" wrote in message news:4b02ddc2.1a15.1681692777 (AT) sybase (DOT) com...
Is there way in SQL Anywhere 11.0.1.2324 to switch off the
"result is non-deterministic" message? Perhaps a database
option?

We have a client application that uses Version 7 which
didn't complain if a sql returned a non-deterministic
record set and would like to avoid rewriting any code.

Check the "Suppress fetch warnings" checkbox on the ODBC driver
configuration dialog ODBC tab. Note that this suppresses a number of
warnings.

-chris

Nick Elson [Sybase iAnywhere] wrote:

Thanks for the replies guys. We could of course alter the
client code, but this would be a considerable ammount of
work.

We also dont connect through ODBC, we have some native C++
componets.

I guess we will have to just bite the bullet and update the
client code.

Phil