db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Soumen Saha" <soumens...@gmail.com>
Subject Re: NULL checking in Derby
Date Sat, 27 Oct 2007 02:37:22 GMT
Hi Brayan,

Could you do in another way? My aim is to delete all the rows where the
OPTION_TEXT is empty..

Regards,
Soumen

On 10/26/07, Bryan Pendleton <bpendleton@amberpoint.com> wrote:
>
> 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