[Objectbridge-developers] Searching for null columns with OQL

[Charles A. <cha...@hp...>]

Hi once again,

I wish to do a search for a null column; how can I do this in OQL ?

I tried "Select aBalance from test.Balance where balanceEndDate is null",
and this produced a parse error. I dug around, and found that the parser
doesn't know anything about "is" or "null", but it knew about something
called 'nil'

So I tried "Select aBalance from test.Balance where balanceEndDate = nil",
which at least was a valid query; it didn't give the expected result though.
The generated SQL was 

"SELECT Balance_ID, Account_Id, balanceStartDate, balanceEndDate,
openingBalance, balance FROM Balance WHERE balanceEndDate= null"

Is it possible to generate "SELECT Balance_ID, Account_Id, balanceStartDate,
balanceEndDate, openingBalance, balance FROM Balance WHERE balanceEndDate is
null" from an OQL query ?

Thankyou once more,

Charles.


This email and any attachments are strictly confidential and are intended
solely for the addressee. If you are not the intended recipient you must
not disclose, forward, copy or take any action in reliance on this message
or its attachments. If you have received this email in error please notify
the sender as soon as possible and delete it from your computer systems.
Any views or opinions presented are solely those of the author and do not
necessarily reflect those of HPD Software Limited or its affiliates.

 At present the integrity of email across the internet cannot be guaranteed
and messages sent via this medium are potentially at risk.  All liability
is excluded to the extent permitted by law for any claims arising as a re-
sult of the use of this medium to transmit information by or to 
HPD Software Limited or its affiliates.