On Nov 22, 2008, at 6:51 AM, phillipm wrote:
>
>
>
> tiggyboo wrote:
>>
>> I created and populated a table via sqlite3 on a Mac OSX machine,
>> and have
>> no problem working with it from the sqlite3 prompt. However, when
>> I try
>> to access the sole table (named cftable) in this database via a very
>> simple Adobe AIR application I'm working on, I get this error:
>>
>> Error #3115: SQL Error.', details:'no such table: cftable'
>>
>> My question - would this be typical of a version conflict for sqlite,
>> i.e., is the latest release of AIR perhaps using an embedded sqlite
>> that
>> is not compatible with what I have (3.1.3) on my machine? I have
>> yet to
>> determine which version is embedded in AIR.
>>
>>
SQLite is fully backwards compatible and mostly forwards compatible.
By backwards compatible, we mean that the latest version of SQLite
will read and write any database file going back to version 3.0.0.
Forwards compatible means that SQLite version 3.0.0 will read and
write database files created with the most recent version of SQLite.
SQLite is 100% backwards compatible and it is forwards compatible
provided that the recent database file does not make use of features
that were added since 3.0.0. Simple database files are very likely to
be forwards compatible.
The version of SQLite used in AIR has been modified to support
additional datatypes, I am told. I am also told that these
modifications are fully compatible at the file-format level, but I
have not been briefed on the details of the modification and so I
cannot comment on them directly. Perhaps the modifications in AIR
exploit features of SQLite that have been added recently and hence
only work with newer versions of SQLite. Or perhaps the modifications
are such that a public-domain version of SQLite will read and write a
database created by AIR but AIR will not read or write a database
created using the public-domain version of SQLite.
To determine a version of SQLite you can run:
SELECT sqlite_version();
If you upgrade to Leopard you will get SQLite version 3.4.0 native to
your OS. (The leopard upgrade is worth doing for many reasons
unrelated to SQLite, in my opinion.) Or you can download the latest
SQLite shell precompiled for MacOSX x86 from the SQLite website and
use that.
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
