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
>/hex

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

Staffan



----- Ursprungligt Meddelande -----
Från: Staffan Tylen <staffan.tylen@gmail.com>
Kopia:
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.
/hex


Absolutely, the current default must be kept.

Staffan





------------------------------------------------------------------------------
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.
http://p.sf.net/sfu/sophos-d2d-feb


_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users