sqlYoga handles sql NULL by converting them to the string "NULL". When writing
back to the table it handles that too. the difference in where clauses is that
you cannot use equal (=) as an operator. You have to use "is". Also I think in
an insert or update statement in the set clause you have to
noticed that too. Doesn't seem to hurt anything.
Bob S
> On Sep 22, 2016, at 10:58 , Matt Maier wrote:
>
> I find myself in want of a YAML library again. Mark posted some functions
> on the forum that I'm debugging
> http://forums.livecode.com/viewtopic.php?f=7&t=21434
>
> Something I discov
On 24/09/2016 04:26, Kay C Lan wrote:
On Fri, Sep 23, 2016 at 2:27 AM, Peter TB Brett
wrote:
"" isn't "the absence of a string", it's a string that's 0 characters long.
Being able to use it as an array key is important for being able to
represent real-world data in an array.
It's an import
Thanks for explaining that gotcha in detail.
I've had a few problems before when I relied on the 99% awesome debugger
and variable watcher only to find out that it wasn't showing me the many
characters that exist, and affect code, but are technically invisible.
On Sat, Sep 24, 2016 at 6:26 AM, Kay
On Fri, Sep 23, 2016 at 2:27 AM, Peter TB Brett
wrote:
>
> "" isn't "the absence of a string", it's a string that's 0 characters long.
> Being able to use it as an array key is important for being able to
> represent real-world data in an array.
It's an important point that "", a 0 character stri
On 22/09/2016 18:58, Matt Maier wrote:
I find myself in want of a YAML library again. Mark posted some functions
on the forum that I'm debugging
http://forums.livecode.com/viewtopic.php?f=7&t=21434
Something I discovered while debugging is that "" is being accepted as an
array key.
It seems lik
Matt Maier wrote:
> Something I discovered while debugging is that "" is being accepted
> as an array key.
>
> It seems like it shouldn't be possible to use the absence of a string
> as an array key. Is it supposed to work that way? I'm using 8.0.1 on
> Windows.
Works that way on Ubuntu 14.04 an
I find myself in want of a YAML library again. Mark posted some functions
on the forum that I'm debugging
http://forums.livecode.com/viewtopic.php?f=7&t=21434
Something I discovered while debugging is that "" is being accepted as an
array key.
It seems like it shouldn't be possible to use the abs