Why not let SQLite handle this for you instead of trying to handle it yourself.  Look up the SQLLite function ifnull()

select ifnull(somecolumn,'ItWasNull') from sometable

On 2/7/2013 12:11 PM, Staffan Tylen wrote:

>Staffan, please post your answer to the list also, if not already

Sorry, didn't realise it didn't go to the list.


----- Ursprungligt Meddelande -----
Från: Staffan Tylen <staffan.tylen@gmail.com>
Datum: torsdag, 07 februari 2013 17:51
Ämne: Re: [Oorexx-users] ooSQLite default NULL value

I was afraid of that :-)

Sorry :(
How will you distinguish a real "" from NULL/.NIL if default is set to "", it can be/often is important to know the real value.

Sometime one needs to, sometimes not.
If Mark is to implement a default value I hope that the current returned value is kept as is, without a need to specify a default value ie. no change to current returned value.

Absolutely, the current default must be kept.


Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.

Oorexx-users mailing list