AIRs SQLite functionality doesnt include everything a standard SQLite database does - i suspect STRFTIME isnt supported in AIR

On 14/12/2013 02:05, Mark Fuqua wrote:
Seriously stumped (almost seems like my normal state).  I have been working
on this most of today.finally figured out how to get a date comparison to
work in SQLite.  Here is the query returning a result in Lita. [1]

Here is a screenshot of the same query inside of a function in a Flex mobile
project. [2]

It is not returning a result.  In Debug, it actually seems to be skipping
the try/catch block entirely and going directly to the bottom 'return null'
statement.  Does anyone spot what I am doing wrong?

Thanks for any help.

[1]

https://www.dropbox.com/s/b3fqnutozd142zf/Screenshot%202013-12-13%2020.54.13
.png

[2]

https://www.dropbox.com/s/xqvvizm7aggqdh6/Screenshot%202013-12-13%2020.54.36
.png

Mark Fuqua

[email protected]

2301 Mount Carmel Road

Parkton,  MD  21120

(410) 215-7356

www.availdata.com




--
Lee Burrows
ActionScripter

Reply via email to