db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: NULL checking in Derby
Date Sat, 27 Oct 2007 01:35:43 GMT
Soumen Saha wrote:
> DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);
> 
> This is working in SQL Server but not in Derby... The error is Error 
> code -1, SQL state 42X01: Syntax error: Encountered "NULL" . Could some 
> one please tell the solution...

Hi Soumen,

I'm afraid I don't know the answer.

I recommend you try asking on derby-user@db.apache.org. I think you
will find a lot more people on that list who know about Derby.

thanks,

bryan


Mime
View raw message