Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 14113 invoked from network); 20 Nov 2006 16:19:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Nov 2006 16:19:10 -0000 Received: (qmail 47424 invoked by uid 500); 20 Nov 2006 16:19:18 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 47398 invoked by uid 500); 20 Nov 2006 16:19:17 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 90309 invoked by uid 99); 20 Nov 2006 14:43:02 -0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Subject: Does Derby support ASSERTION? Date: Mon, 20 Nov 2006 10:43:55 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C70CB2.4F5E1CF1" Message-ID: <6B93DDB987CEF843BA4C24C7AA3181772822@pttmail.ptt.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5 Thread-Topic: Does Derby support ASSERTION? Thread-Index: AccMsk4kSLWb2/TkRqSOKTLRY3l0pg== From: "Sisilla Sookdeo" To: X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C70CB2.4F5E1CF1 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello All, =20 I tried executing the following SQL code in NetBeans IDE: =20 CREATE ASSERTION PartialRetiringEquipment =20 CHECK=20 ( =20 (SELECT COUNT (R.PTTEquipmentID) FROM RetiredEquipment R) < =3D =20 (SELECT COUNT (All.PTTEquipmentID) FROM Equipment All) ) =20 I received the following error message: An error has occurred during execution: Syntax error: Encountered "ASSERTION" at line 1, column 8 =20 I am using Derby 10.2.1.6 on Windows XP Professional. I appreciate any help. =20 Thanks, Sisilla ------_=_NextPart_001_01C70CB2.4F5E1CF1 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello All,

 

I tried executing the following SQL code in NetBeans IDE:

 

CREATE ASSERTION PartialRetiringEquipment  =

CHECK

(  

(SELECT COUNT = (R.PTTEquipmentID) FROM RetiredEquipment R) < =3D   =

(SELECT COUNT = (All.PTTEquipmentID) FROM Equipment All)

 )

 

I received the following error = message:

An error has occurred during execution: Syntax error: Encountered “ASSERTION” at line 1, column = 8

 

I am using Derby = 10.2.1.6 on Windows XP Professional. I appreciate any = help.

 

Thanks,

Sisilla

------_=_NextPart_001_01C70CB2.4F5E1CF1--