db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sisilla Sookdeo" <sisil...@paramounttransport.com>
Subject Does Derby support ASSERTION?
Date Mon, 20 Nov 2006 14:43:55 GMT
Hello All,

 

I tried executing the following SQL code in NetBeans IDE:

 

CREATE ASSERTION PartialRetiringEquipment  

CHECK 

(   

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

(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


Mime
View raw message