I posted a thread on Adobe forums to confirm that you could select from a view.
So I have no clue what is happening inside the proxy/table prototypes.
Try the new SQLiteStore. It's available now in this thread.
Programming today is a race between software engineers striving to build bigger and better ?diot-proof programs, and the universe striving to produce bigger and better idiots. So far, the universe is winning. (Rick Cook)
Enhanced ExtJS adapter for Adobe AIR
[SOLVED] Sqlite Views
Thank you Makana, still testing the new adapter and lovin it so far.
So here is the problem and solution - Firefox SQLiteManager Add-on 3.16 CANNOT be trusted.
I create a database from scratch using the SQLite3 command line and all my views are accessible without any problems.
The I tested accessing the database created with SQLiteManager Add-on and found that my views never appeared in teh sqlite_master table !!!!
Well, at least I don't need to pay for a hair cut this month, as I've gone bald from Firefox, my first ever disaproval of one of their products.
why Firefox SQLiteManager Add-on 3.16 isn't trust worth then which one do you recommend ?