AW: [Objectbridge-developers] Searching for null columns with OQL

[Mahler T. <tho...@it...>]

Hi,

As I see it IS NULL is currently not supported. Neither by my OQL
implementation nor by the PersistenceBroker Query mechanism.

I added this as an urgent feature request...

Thanks for your patience with OJB...

--Thomas

> -----Urspr=FCngliche Nachricht-----
> Von: Charles Anthony [mailto:cha...@hp...]
> Gesendet: Montag, 24. September 2001 16:05
> An: 'obj...@li...'
> Betreff: [Objectbridge-developers] Searching for null columns with =
OQL
>=20
>=20
> Hi once again,
>=20
> I wish to do a search for a null column; how can I do this in OQL ?
>=20
> I tried "Select aBalance from test.Balance where=20
> balanceEndDate is null",
> and this produced a parse error. I dug around, and found that=20
> the parser
> doesn't know anything about "is" or "null", but it knew about=20
> something
> called 'nil'
>=20
> So I tried "Select aBalance from test.Balance where=20
> balanceEndDate =3D nil",
> which at least was a valid query; it didn't give the expected=20
> result though.
> The generated SQL was=20
>=20
> "SELECT Balance_ID, Account_Id, balanceStartDate, balanceEndDate,
> openingBalance, balance FROM Balance WHERE balanceEndDate=3D null"
>=20
> Is it possible to generate "SELECT Balance_ID, Account_Id,=20
> balanceStartDate,
> balanceEndDate, openingBalance, balance FROM Balance WHERE=20
> balanceEndDate is
> null" from an OQL query ?
>=20
> Thankyou once more,
>=20
> Charles.
>=20
>=20
> This email and any attachments are strictly confidential and=20
> are intended
> solely for the addressee. If you are not the intended=20
> recipient you must
> not disclose, forward, copy or take any action in reliance on=20
> this message
> or its attachments. If you have received this email in error=20
> please notify
> the sender as soon as possible and delete it from your=20
> computer systems.
> Any views or opinions presented are solely those of the=20
> author and do not
> necessarily reflect those of HPD Software Limited or its affiliates.
>=20
>  At present the integrity of email across the internet cannot=20
> be guaranteed
> and messages sent via this medium are potentially at risk. =20
> All liability
> is excluded to the extent permitted by law for any claims=20
> arising as a re-
> sult of the use of this medium to transmit information by or to=20
> HPD Software Limited or its affiliates.
>=20
>=20
>=20
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20