On Thu, Feb 7, 2013 at 8:49 AM, hakan <hexit34@users.sourceforge.net> wrote:

----- Ursprungligt Meddelande -----
Från: hakan <hexit34@users.sourceforge.net>
Till: Staffan Tylen <staffan.tylen@gmail.com>
Datum: torsdag, 07 februari 2013 17:47
Ämne: Re: [Oorexx-users] ooSQLite default NULL value
I was afraid of that :-)
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.
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.


The default will definitely stay at .nil.  You would need to change your code to purposively change the value for SQL NULL to be something other than .nil.

Also, I need to go through the code, and be sure .nil is always returned for NULL.  It should be, but I'm not 100% sure I was consistent in the code.

Mark Miesfeld