Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

"Option value out of range. Update operation attempted on read only cursor"

9 posts in General Discussion Last posting was on 2003-11-24 14:24:04.0Z
Riyas Noushad Posted on 2003-10-14 07:41:00.0Z
From: "Riyas Noushad" <riyas@buck.com.sg>
Newsgroups: ianywhere.public.general
Subject: "Option value out of range. Update operation attempted on read only cursor"
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 202.148.175.68
Message-ID: <3f8ba96b$1@forums-2-dub>
X-Original-Trace: 14 Oct 2003 00:44:43 -0700, 202.148.175.68
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Oct 2003 00:34:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Oct 2003 00:41:00 -0700
X-Trace: forums-1-dub 1066117260 10.22.108.75 (14 Oct 2003 00:41:00 -0700)
X-Original-Trace: 14 Oct 2003 00:41:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1853
Article PK: 4105

We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and after migration, in
our application we are getting the following error message :

"Option value out of range. Update operation attempted on read only cursor"

Can any one tell how to overcome this problem.


--
Thanks,
Riyas


Glenn Paulley Posted on 2003-10-14 13:35:22.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
References: <3f8ba96b$1@forums-2-dub>
In-Reply-To: <3f8ba96b$1@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3f8bfb9a$1@forums-1-dub>
Date: 14 Oct 2003 06:35:22 -0700
X-Trace: forums-1-dub 1066138522 172.31.142.134 (14 Oct 2003 06:35:22 -0700)
X-Original-Trace: 14 Oct 2003 06:35:22 -0700, paulley-xp.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1855
Article PK: 4103

We need more details. Please provide the statement that was being
executed when this error was generated, and also the value of the
ANSI_UPDATE_CONSTRAINTS option at that time.

Glenn

Riyas Noushad wrote:
> We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and after migration, in
> our application we are getting the following error message :
>
> "Option value out of range. Update operation attempted on read only cursor"
>
> Can any one tell how to overcome this problem.
>
>
> --
> Thanks,
> Riyas
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


Chris Keating (iAnywhere Solutions) Posted on 2003-10-14 13:54:02.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3f8ba96b$1@forums-2-dub>
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3f8bfffa@forums-1-dub>
Date: 14 Oct 2003 06:54:02 -0700
X-Trace: forums-1-dub 1066139642 172.31.140.66 (14 Oct 2003 06:54:02 -0700)
X-Original-Trace: 14 Oct 2003 06:54:02 -0700, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1856
Article PK: 4106

See ANSI_UPDATE_CONSTRAINTS option. It is referenced in the Behaviour
changes for ASA7 (see What's New in SQL Anywhere Studio for information on
both the new features and behaviour changes introduced).

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Riyas Noushad" <riyas@buck.com.sg> wrote in message
news:3f8ba96b$1@forums-2-dub...
> We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and after migration,
in
> our application we are getting the following error message :
>
> "Option value out of range. Update operation attempted on read only
cursor"
>
> Can any one tell how to overcome this problem.
>
>
> --
> Thanks,
> Riyas
>
>


Riyas Posted on 2003-11-03 01:42:04.0Z
Sender: 4b41.3fa5b29c.1804289383@sybase.com
From: Riyas
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa5b391.4b45.846930886@sybase.com>
References: <3f8ba96b$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Nov 2003 17:46:58 -0800, 10.22.241.42
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Nov 2003 17:34:00 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Nov 2003 17:42:04 -0800
X-Trace: forums-1-dub 1067823724 10.22.108.75 (2 Nov 2003 17:42:04 -0800)
X-Original-Trace: 2 Nov 2003 17:42:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1994
Article PK: 4222

Hi Glenn,

We are using quite a few SQL statements and we are not able
to locate as for which SQL the message is prompted. This
error message appreaing when we are trying to select some
item from a drop down datawindow and it is not consistent in
the sense, the error that appears for an item does not
appear for the same item again for a few cycles.

Nothing was changed for ANSI_UPDATE_CONSTRAINTS option and
is the default value.


Thanks,
Riyas.

> We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and
> after migration, in our application we are getting the
> following error message :
>
> "Option value out of range. Update operation attempted on
> read only cursor"
>
> Can any one tell how to overcome this problem.
>
>
> --
> Thanks,
> Riyas
>
>


Glenn Paulley Posted on 2003-11-03 13:26:46.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
References: <3f8ba96b$1@forums-2-dub> <3fa5b391.4b45.846930886@sybase.com>
In-Reply-To: <3fa5b391.4b45.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3fa65796$1@forums-1-dub>
Date: 3 Nov 2003 05:26:46 -0800
X-Trace: forums-1-dub 1067866006 172.31.142.134 (3 Nov 2003 05:26:46 -0800)
X-Original-Trace: 3 Nov 2003 05:26:46 -0800, paulley-xp.sybase.com
Lines: 62
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1997
Article PK: 4223

ANSI_UPDATE_CONSTRAINTS is a relatively new option that did not exist in
ASA 5.5. It's default is OFF, which means that if your application
performs update operations on complex cursors (ie. involving joins) that
are not permitted by the ANSI SQL99 standard, then you'll get this error.

Also - I would strongly recommend that you unload/reload your database
to an 8.0.2 database format, rather than simply upgrading your old 5.5.
database. Until you do, you'll be missing out on many of the performance
features of 8.x.

Glenn

Riyas wrote:
> Hi Glenn,
>
> We are using quite a few SQL statements and we are not able
> to locate as for which SQL the message is prompted. This
> error message appreaing when we are trying to select some
> item from a drop down datawindow and it is not consistent in
> the sense, the error that appears for an item does not
> appear for the same item again for a few cycles.
>
> Nothing was changed for ANSI_UPDATE_CONSTRAINTS option and
> is the default value.
>
>
> Thanks,
> Riyas.
>
>
>>We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and
>>after migration, in our application we are getting the
>>following error message :
>>
>>"Option value out of range. Update operation attempted on
>>read only cursor"
>>
>>Can any one tell how to overcome this problem.
>>
>>
>>--
>>Thanks,
>>Riyas
>>
>>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


Riyas Posted on 2003-11-20 02:43:05.0Z
Sender: 22c1.3fbc28fa.1804289383@sybase.com
From: Riyas
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fbc2a39.22c6.846930886@sybase.com>
References: <3f8ba96b$1@forums-2-dub> <3fa5b391.4b45.846930886@sybase.com><3fa65796$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2003 18:43:05 -0800
X-Trace: forums-1-dub 1069296185 10.22.241.41 (19 Nov 2003 18:43:05 -0800)
X-Original-Trace: 19 Nov 2003 18:43:05 -0800, 10.22.241.41
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2110
Article PK: 4328

Hi Glenn,

Based on the explanation given for the
ANSI_UPDATE_CONSTRAINTS property in the Help file, it looks
that the property to be set to OFF in order for update
operations in cursors. The other two options STRICT and
CURSOR will be more restricted than OFF.

Is there is any other solution for this?

Regarding the upgrade,please note that we cannot directly
upgrade 5.5 to 8. It has to be done by Unloading/Loading
only.

Thanks,
Riyas.

> ANSI_UPDATE_CONSTRAINTS is a relatively new option that
> did not exist in ASA 5.5. It's default is OFF, which
> means that if your application performs update operations
> on complex cursors (ie. involving joins) that are not
> permitted by the ANSI SQL99 standard, then you'll get this
> error.
>
> Also - I would strongly recommend that you unload/reload
> your database to an 8.0.2 database format, rather than
> simply upgrading your old 5.5. database. Until you do,
> you'll be missing out on many of the performance features
> of 8.x.
>
> Glenn
>
> Riyas wrote:
> > Hi Glenn,
> >
> > We are using quite a few SQL statements and we are not
> > able to locate as for which SQL the message is prompted.
> > This error message appreaing when we are trying to
> > select some item from a drop down datawindow and it is
> > not consistent in the sense, the error that appears for
> > an item does not appear for the same item again for a
> > few cycles.
> > Nothing was changed for ANSI_UPDATE_CONSTRAINTS option
> > and is the default value.
> >
> >
> > Thanks,
> > Riyas.
> >
> >
> >>We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and
> >>after migration, in our application we are getting the
> >>following error message :
> >>
> >>"Option value out of range. Update operation attempted
> on >>read only cursor"
> >>
> >>Can any one tell how to overcome this problem.
> >>
> >>
> >>--
> >>Thanks,
> >>Riyas
> >>
> >>
>
> --
> Glenn Paulley
> Research and Development Manager, Query Processing
> iAnywhere Solutions Engineering
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer
>


Glenn Paulley Posted on 2003-11-20 15:12:29.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on read only cursor"
References: <3f8ba96b$1@forums-2-dub> <3fa5b391.4b45.846930886@sybase.com><3fa65796$1@forums-1-dub> <3fbc2a39.22c6.846930886@sybase.com>
In-Reply-To: <3fbc2a39.22c6.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3fbcd9dd$1@forums-1-dub>
Date: 20 Nov 2003 07:12:29 -0800
X-Trace: forums-1-dub 1069341149 172.31.142.134 (20 Nov 2003 07:12:29 -0800)
X-Original-Trace: 20 Nov 2003 07:12:29 -0800, paulley-xp.sybase.com
Lines: 112
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2114
Article PK: 4330

Setting it to OFF is likely necessary for your application. You should
set ANSI_UPDATE_CONSTRAINTS permanently after you do the unload/reload.

Glenn

Riyas wrote:
> Hi Glenn,
>
> Based on the explanation given for the
> ANSI_UPDATE_CONSTRAINTS property in the Help file, it looks
> that the property to be set to OFF in order for update
> operations in cursors. The other two options STRICT and
> CURSOR will be more restricted than OFF.
>
> Is there is any other solution for this?
>
> Regarding the upgrade,please note that we cannot directly
> upgrade 5.5 to 8. It has to be done by Unloading/Loading
> only.
>
> Thanks,
> Riyas.
>
>
>
>>ANSI_UPDATE_CONSTRAINTS is a relatively new option that
>>did not exist in ASA 5.5. It's default is OFF, which
>>means that if your application performs update operations
>>on complex cursors (ie. involving joins) that are not
>>permitted by the ANSI SQL99 standard, then you'll get this
>>error.
>>
>>Also - I would strongly recommend that you unload/reload
>>your database to an 8.0.2 database format, rather than
>>simply upgrading your old 5.5. database. Until you do,
>>you'll be missing out on many of the performance features
>>of 8.x.
>>
>>Glenn
>>
>>Riyas wrote:
>>
>>>Hi Glenn,
>>>
>>>We are using quite a few SQL statements and we are not
>>>able to locate as for which SQL the message is prompted.
>>>This error message appreaing when we are trying to
>>>select some item from a drop down datawindow and it is
>>>not consistent in the sense, the error that appears for
>>>an item does not appear for the same item again for a
>>>few cycles.
>>>Nothing was changed for ANSI_UPDATE_CONSTRAINTS option
>>>and is the default value.
>>>
>>>
>>>Thanks,
>>>Riyas.
>>>
>>>
>>>
>>>>We did DB upgrade from SQL Anywhere 5.5.04 to ASA 8 and
>>>>after migration, in our application we are getting the
>>>>following error message :
>>>>
>>>>"Option value out of range. Update operation attempted
>>
>>on >>read only cursor"
>>
>>>>Can any one tell how to overcome this problem.
>>>>
>>>>
>>>>--
>>>>Thanks,
>>>>Riyas
>>>>
>>>>
>>
>>--
>>Glenn Paulley
>>Research and Development Manager, Query Processing
>>iAnywhere Solutions Engineering
>>
>>EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>>To Submit Bug Reports:
>>http://casexpress.sybase.com/cx/cx.stm
>>
>>SQL Anywhere Studio Supported Platforms and Support Status
>>http://my.sybase.com/detail?id=1002288
>>
>>Whitepapers, TechDocs, and bug fixes are all available
>>through the iAnywhere Developer Community at
>>www.ianywhere.com/developer
>>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


Breck Carter [TeamSybase] Posted on 2003-11-22 17:22:33.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on readonly cursor"
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <k36vrv0rppp02fnc6lknpr91m879jle7q3@4ax.com>
References: <3f8ba96b$1@forums-2-dub> <3fa5b391.4b45.846930886@sybase.com> <3fa65796$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 22 Nov 2003 09:28:37 -0800, bcarter.sentex.ca
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Nov 2003 09:12:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Nov 2003 09:22:33 -0800
X-Trace: forums-1-dub 1069521753 10.22.108.75 (22 Nov 2003 09:22:33 -0800)
X-Original-Trace: 22 Nov 2003 09:22:33 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2120
Article PK: 4336

On 3 Nov 2003 05:26:46 -0800, Glenn Paulley <paulley@ianywhere.com>

wrote:

>ANSI_UPDATE_CONSTRAINTS is a relatively new option that did not exist in
>ASA 5.5. It's default is OFF, which means that if your application
>performs update operations on complex cursors (ie. involving joins) that
>are not permitted by the ANSI SQL99 standard, then you'll get this error.

That sounds like the description of the CURSORS setting, not the OFF
setting, at least according to the V8 Help.

Breck
--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Glenn Paulley Posted on 2003-11-24 14:24:04.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: "Option value out of range. Update operation attempted on readonly cursor"
References: <3f8ba96b$1@forums-2-dub> <3fa5b391.4b45.846930886@sybase.com> <3fa65796$1@forums-1-dub> <k36vrv0rppp02fnc6lknpr91m879jle7q3@4ax.com>
In-Reply-To: <k36vrv0rppp02fnc6lknpr91m879jle7q3@4ax.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3fc215f8$1@forums-2-dub>
X-Original-Trace: 24 Nov 2003 06:30:16 -0800, paulley-xp.sybase.com
Lines: 42
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Nov 2003 06:13:55 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Nov 2003 06:24:04 -0800
X-Trace: forums-1-dub 1069683844 10.22.108.75 (24 Nov 2003 06:24:04 -0800)
X-Original-Trace: 24 Nov 2003 06:24:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2123
Article PK: 4339

Thanks for correcting me, Breck. The default is CURSORS in new
databases; OFF in databases created before 7.0. In any case, it is
likely the setting of ANSI_UPDATE_CONSTRAINTS that is causing this error.

Glenn

Breck Carter [TeamSybase] wrote:
> On 3 Nov 2003 05:26:46 -0800, Glenn Paulley <paulley@ianywhere.com>
> wrote:
>
>
>>ANSI_UPDATE_CONSTRAINTS is a relatively new option that did not exist in
>>ASA 5.5. It's default is OFF, which means that if your application
>>performs update operations on complex cursors (ie. involving joins) that
>>are not permitted by the ANSI SQL99 standard, then you'll get this error.
>
>
> That sounds like the description of the CURSORS setting, not the OFF
> setting, at least according to the V8 Help.
>
> Breck
> --
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer