?
> What do you mean, NULL is NULL (.NIL is .NIL)
> and default to what ? NULL or .NIL or "something else", if "something
> else" the I suggest you populate the tablevalue with "something else" when
> tablevalue is written.
> /hex
>
>
If I do this:
a=.oosqliteconnection("my.db")
b = a~exec("select * from tbl1",.true,.oosqlite~oo_array_of_array)
then b will contain x number of arrays, where some of the values might by
The NIL Object (.NIL) indicating that the value is NULL in the db.
Depending on the code one may have to manually test for .NIL to avoid
syntax errors and other unwanted situations when manipulating the array
values.
By doing for example:
a~defaultNULL = ""
one can be sure that no .NIL values exist in the arrays. Or one might use
a~defaultNULL = "NULL" or a~defaultNULL = "Undecided" or whatever might be
best in that situation.
I hope this helps.
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
