SQLite Problem in 4.5

[Bob Sneidar]

Ah hah! Nice catch. I thought Rev was supposed to interpret NULL as empty string, but with the concatenation, I suppose the NULL's would be embedded in the returned pseudo column (probably not the right word for it). That is a nice little gotcha there for anyone running this kind of query. Moral to story: avoid NULL values in LiveCode SQL databases? 

Bob


On Nov 15, 2010, at 2:58 PM, Peter Haworth wrote:

> Thanks Bob.  I think the problem may have something to do with NULL values in some of the columns coming back from the SELECT.  When I fixed them, the SELECT worked fine in LiveCode.  The Firefox plugin was one of the utilities I used to check this out and it returned all the data correctly, even when there were NULLs in the columns.
> 
> Pete Haworth