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.

Constraints

3 posts in General Discussion Last posting was on 2011-04-06 21:32:32.0Z
Sheryl Posted on 2011-04-06 16:41:55.0Z
Sender: 2b4e.4d9c9740.1804289383@sybase.com
From: Sheryl
Newsgroups: sybase.public.workspace.general
Subject: Constraints
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d9c97d3.2b5f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Apr 2011 09:41:55 -0700
X-Trace: forums-1-dub 1302108115 10.22.241.41 (6 Apr 2011 09:41:55 -0700)
X-Original-Trace: 6 Apr 2011 09:41:55 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:949
Article PK: 1101477

I have a table with constraints yet Sybase allows me to
enter data that does not abide by these constraints. I've
worked with Sybase for many years and have not come across
this before. Any idea how and why this is happening?


Sheryl Posted on 2011-04-06 18:29:14.0Z
Sender: 2cb8.4d9ca4de.1804289383@sybase.com
From: Sheryl
Newsgroups: sybase.public.workspace.general
Subject: Re: Constraints
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d9cb0fa.2f4b.1681692777@sybase.com>
References: <4d9c97d3.2b5f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Apr 2011 11:29:14 -0700
X-Trace: forums-1-dub 1302114554 10.22.241.41 (6 Apr 2011 11:29:14 -0700)
X-Original-Trace: 6 Apr 2011 11:29:14 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:950
Article PK: 1101478


> I have a table with constraints yet Sybase allows me to
> enter data that does not abide by these constraints. I've
> worked with Sybase for many years and have not come across
> this before. Any idea how and why this is happening?

Additional findings...
This is only true if the constraint is a multi-part
constraint and the value for part 1 is null. Also, I've only
tested using Sybase 10.


"Mark A. Parsons" <iron_horse Posted on 2011-04-06 21:32:32.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Constraints
References: <4d9c97d3.2b5f.1681692777@sybase.com> <4d9cb0fa.2f4b.1681692777@sybase.com>
In-Reply-To: <4d9cb0fa.2f4b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d9cdbf0$1@forums-1-dub>
Date: 6 Apr 2011 14:32:32 -0700
X-Trace: forums-1-dub 1302125552 10.22.241.152 (6 Apr 2011 14:32:32 -0700)
X-Original-Trace: 6 Apr 2011 14:32:32 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:951
Article PK: 1101479

I'd suggest you provide the table's complete definition, including constraints. (either the ddl used to create the
table or the results of sp_help and sp_helpconstraint)

As for your comment about Sybase 10 ...

If you're referring to ASE (Adaptive Server Enterprise) then you're using a product that's more than 15 years old ...
and you would be much better off getting a newer/recent version of ASE.

If you're referring to SQLAnywhere (aka ASA == Adaptive Server Anywhere) then you're in the the wrong newsgroup (this is
an ASE newsgroup, you want a SQLAnywhere newsgroup ... like sybase.public.sqlanywhere.general).

On 04/06/2011 14:29, Sheryl wrote:
>> I have a table with constraints yet Sybase allows me to
>> enter data that does not abide by these constraints. I've
>> worked with Sybase for many years and have not come across
>> this before. Any idea how and why this is happening?
>
> Additional findings...
> This is only true if the constraint is a multi-part
> constraint and the value for part 1 is null. Also, I've only
> tested using Sybase 10.