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.ty...@gmail.com>
<mailto:staffan.ty...@gmail.com>
*Till:* <hexi...@users.sourceforge.net>
<mailto:hexi...@users.sourceforge.net>
*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
------------------------------------------------------------------------------
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
