SQLError: Error #3129: The database schema changed with Flex and AIR SQL Lite Database
This error occures when you create new tables and then try to insert, select, etc during the same database connection.
Adobe has it listed on their runtime errors page.
| 3129 | The database schema changed. |
Indicates that the operation could not
be completed because of a schema error. This occurs when the schema of the
database changes after a statement is prepared but before it finishes executing,
such as if two SQLConnection instances are connected to the same database,
and one instance changes the schema while another one is reading it.
The solution is to use the .close() method. For example. SomeSQLLiteDB.close() should be the last statement after creating your new tables. Then use SomeSQLLiteDB.open() before your insert, select, etc statement is executed. |
The solution is to call the .close() method when you complete creating your tables. Then you can call the .connect() method and select, insert, etc from the newly created tables.
SomeSQLLiteDB.close()
SomeSQLLiteDB.connect()
Recent Comments