On Thu, Feb 7, 2013 at 6:54 AM, Staffan Tylen <staffan.tylen@gmail.com> wrote:
Mark, would it be possible to introduce a new attribute to the ooSQLiteConnection class that allows for setting a default output value for NULL, which I believe is .NIL today?

Yeah I think it is possible.  .nil is the best choice, as its meaning in ooRexx and its meaning in SQL are equivalent.

But, off of the top of my head without looking at the code, I don't see any reason why an attribute similar to the result format attribute couldn't be added for the SQL NULL.

A RFE so the idea does not get forgotten is probably needed.  ;-)

Mark Miesfeld

I'm aware that you added this possibility when populating a listview from an array, but when the data is not to be placed in a listview one have to manually check the output from ooSQLite for .NIL on all fields where it can exist, causing both unnecessary work, errors, and overhead.


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