SQLError: 'Error #3122', details:'', operation:'execute'

[ffzhuang]

Hi, All:

I try to run AIR 1.5 + extjs 2.2/3.0 (Aaron latest version) + SQLite. I have a simple list, CRUD demo. I meet a weird issue:

1: When I installed it in a slow machine (1.5G memory window XP), everything work fine. Not problem

2: When I installed it in a latest machine (3G Memory window Vista). I have the following issue during SAVE/Delete record:

SQLError: 'Error #3122', details:'', operation:'execute'

3: In both case, it does not have any problem when I run demo inside Aptana.

And I track back the code, seem this one make trouble in Ext.sql.AirConnection



execBy : function(sql, args){
var stmt = this.createStatement('exec');
stmt.text = sql;
this.addParams(stmt, args); // take too long ?
stmt.execute();
},
For me, it seems javascript Asynchonize issue. Any one have the same issue ?

Furthermore, I have the same issue when I install task demo from extjs site - my env is AIR1.5 + extjs 2.2

Any suggestion and help would be really appreciated.

Regards!

Fenqiang Zhuang

11187 Error Screen shot

[ffzhuang]

S H I T .... did not read Adobe document really careful.

Adobe told us, we should use applicationStorage path not just application path (not sure if this is correct name, but I did not have enough sleep past 2 days :) )

I installed it in my Vista/program files, and my DB file is read only (Vista make this - it is not me, right? I already complain too much for IE - Vista is really good ? / I means compare with IE) - so this means I can not save to the sqlite file.

Ok, hopefully anyone not hit this issue anymore. Drive me crazy - however, it forces me to read ext-air code. That is good thing

Regards!

Fenqiang Zhuang