SQLite version - Air version ??

Thank you for your input. When using 2 it signals the relational database to sort by #2. This si within the table structure and references the column_id.

I'm still getting the same issue, and the onyl thing I can think of is what version of SQLite are you using.

I started up the SQLite Manager and I see version 3.6.16.1. This is just about the only thing I can think of. Otherwise, I'm going to shutdown this old cow struggling to run aptana.

Also, Makana, can you tell me which version of Air you are running? I'm running Beta 2.0. But if one of my comboxes has not problem accessing SQLite, and don't see the relation, but nonetheless, good to know what versiosn we are running.

SQLite Store - views/tables and rowid?

Hello,

So I'm still unable to query the views I've created in my SQLite database. After some searching, I've ntoiced tha tthe only difference between a table and a view is that SQlite adds a system rowid. Could this play a role?

Also, could some some please explain what Ext means by this :

/**
* @class Ext.sql.SQLiteStore
* @extends Ext.data.Store
* Convenience class which assists in setting up SQLiteStore's.
* This class will create the necessary table if it does not exist.
* This class requires that all fields stored in the database will also be kept
* in the Ext.data.Store.
*/

Where is the SQLite version from? You don't need to install anything, but Adobe Air. How are you creating the iApplication.module.DB ?
And what about the debugging? Are the generated SQL-commands okay?

"Error #1056: Cannot create property stackTrace on flash.errors.SQLError."
As you see, it is an sql-error. So I don't think the problem is the ext.js.
What IDE are you using for debugging? Run your application in debug-mode and you will see, where the error occurs and what the SQL-Error exactly is. I think you will also see the generated sql command, which causes the error!

Aptana has great debugging features. Why don't you just run the debugger and check, which sql-command is generated and which error is thrown?
Set a breakpoint on line 33193 of the ext-all-debug.js. On line 33204 look what's inside the variable "e".