Re: [sqlite] Adobe AIR Version Issue(?)

[DMcQ]

Ben,

Thanks for the quick response. My problem turned out to be that I was
setting the sqlConnection property of my SQLStatement instances before the
connection was actually made. So when I ran those statements with a 

stmt.execute()

nuthin' happened as my program has a way of (always) doing what it's told.

Daniel
-- 
View this message in context: 
http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p20876079.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Ben Marchbanks]

My project essentially creates a backup of selected records from mySQL 
in SQLite.

If I don't completely delete the previous backup (SQLite database file) 
I cannot create
a new backup. In otherwords the database is locked and I cannot drop 
tables etc

Simple work-around for me was to delete the db file and start fresh.


If you are using AIR besure to "clean project" to move your sqlite 
database to the bin-debug folder.
I had the same issue just today - I realized my updated SQLite table was 
not being used by the debugger.


*Ben Marchbanks*

www.magazooms.com 
Signature
Email: [EMAIL PROTECTED] 
Phone: (864) 284.9918


DMcQ wrote:
> Hi Ben,
>
> Would you mind explaining what you mean by " delete the previous sqlite
> backup file"? 
>
> I'm running into a 'no table found' error (when I can see it's there using
> SQLite Data Browser app), but I don't know of any backup file that's
> created. 
>
> Any hints greatly appreciated.
>
> Daniel
>
>
> Ben Marchbanks-2 wrote:
>   
>> Yes I did resolve it using a large hammer -
>>
>> I just delete the previous sqlite backup file using ulink since for my 
>> purposes its a total
>> backup anyway.
>>
>> It would be good to know how to do incremental changes as an option - 
>> let me know if you find a solution.
>>
>> One thing I did notice is that the file permission were set to 
>> -rwx-rwx-r-x instead of drwx-rwx--r-x as
>> I would expect using chmod 0775.
>>
>> I think that PHP-PDO is a clumsy implementation.
>>
>> *Ben Marchbanks*
>>
>> www.magazooms.com 
>> Signature
>> Email: [EMAIL PROTECTED] 
>> Phone: (864) 284.9918
>>
>>
>> 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.

 Thanks,
 Al

 
 
>>> Just wondering if you resolved this issue - I'm experiencing the same
>>> situation. Very simple project, small database in the project folder?
>>>
>>> Any help appreciated, thanks
>>>
>>>
>>> Phil
>>>   
>>>   
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>> 
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[DMcQ]

Hi Ben,

Would you mind explaining what you mean by " delete the previous sqlite
backup file"? 

I'm running into a 'no table found' error (when I can see it's there using
SQLite Data Browser app), but I don't know of any backup file that's
created. 

Any hints greatly appreciated.

Daniel


Ben Marchbanks-2 wrote:
> 
> Yes I did resolve it using a large hammer -
> 
> I just delete the previous sqlite backup file using ulink since for my 
> purposes its a total
> backup anyway.
> 
> It would be good to know how to do incremental changes as an option - 
> let me know if you find a solution.
> 
> One thing I did notice is that the file permission were set to 
> -rwx-rwx-r-x instead of drwx-rwx--r-x as
> I would expect using chmod 0775.
> 
> I think that PHP-PDO is a clumsy implementation.
> 
> *Ben Marchbanks*
> 
> www.magazooms.com 
> Signature
> Email: [EMAIL PROTECTED] 
> Phone: (864) 284.9918
> 
> 
> 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.
>>>
>>> Thanks,
>>> Al
>>>
>>> 
>>
>> Just wondering if you resolved this issue - I'm experiencing the same
>> situation. Very simple project, small database in the project folder?
>>
>> Any help appreciated, thanks
>>
>>
>> Phil
>>   
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p20875089.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Dusan Gibarac]

Ignore this, did not read all the comments...

Dusan.



Dusan Gibarac wrote:
> from the message (missing cftable) one can conclude that AIR is looking 
> for ColdFusion database, not SQLite one;
> So, some settings in (probably) FLEX has to be adjusted.
>
> Dusan.
>
>
>
> 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.
>>>
>>> Thanks,
>>> Al
>>>
>>> 
>>>   
>> Just wondering if you resolved this issue - I'm experiencing the same
>> situation. Very simple project, small database in the project folder?
>>
>> Any help appreciated, thanks
>>
>>
>> Phil
>>   
>> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Dusan Gibarac]

from the message (missing cftable) one can conclude that AIR is looking 
for ColdFusion database, not SQLite one;
So, some settings in (probably) FLEX has to be adjusted.

Dusan.



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.
>>
>> Thanks,
>> Al
>>
>> 
>
> Just wondering if you resolved this issue - I'm experiencing the same
> situation. Very simple project, small database in the project folder?
>
> Any help appreciated, thanks
>
>
> Phil
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[phillipm]

Thanks for the responses guys. I'll get my hammer out :o)

Cheers

Phil



Ben Marchbanks-2 wrote:
> 
> If you haven't already downloaded it checkout Christian Coenreats SQLite 
> Admin written in AIR.
> 
> http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/
> 
> Its a big help for me as my SQLite dbs are created on a Linux server (a 
> select backup from mySQL) and
> then I embed them into my AIR project on mac OSX.
> 
> SQLite Admin helps verify schema and test queries etc...
> 
> 
> *Ben Marchbanks*
> 
> www.magazooms.com 
> Signature
> Email: [EMAIL PROTECTED] 
> Phone: (864) 284.9918
> 
> 
> Ben Marchbanks wrote:
>> Yes I did resolve it using a large hammer -
>>
>> I just delete the previous sqlite backup file using ulink since for my 
>> purposes its a total
>> backup anyway.
>>
>> It would be good to know how to do incremental changes as an option - 
>> let me know if you find a solution.
>>
>> One thing I did notice is that the file permission were set to 
>> -rwx-rwx-r-x instead of drwx-rwx--r-x as
>> I would expect using chmod 0775.
>>
>> I think that PHP-PDO is a clumsy implementation.
>>
>> *Ben Marchbanks*
>>
>> www.magazooms.com 
>> Signature
>> Email: [EMAIL PROTECTED] 
>> Phone: (864) 284.9918
>>
>>
>> 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.

 Thanks,
 Al

 
   
>>> Just wondering if you resolved this issue - I'm experiencing the same
>>> situation. Very simple project, small database in the project
>>> folder?
>>>
>>> Any help appreciated, thanks
>>>
>>>
>>> Phil
>>>   
>>> 
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>>   
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p20640008.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Ben Marchbanks]

If you haven't already downloaded it checkout Christian Coenreats SQLite 
Admin written in AIR.

http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/

Its a big help for me as my SQLite dbs are created on a Linux server (a 
select backup from mySQL) and
then I embed them into my AIR project on mac OSX.

SQLite Admin helps verify schema and test queries etc...


*Ben Marchbanks*

www.magazooms.com 
Signature
Email: [EMAIL PROTECTED] 
Phone: (864) 284.9918


Ben Marchbanks wrote:
> Yes I did resolve it using a large hammer -
>
> I just delete the previous sqlite backup file using ulink since for my 
> purposes its a total
> backup anyway.
>
> It would be good to know how to do incremental changes as an option - 
> let me know if you find a solution.
>
> One thing I did notice is that the file permission were set to 
> -rwx-rwx-r-x instead of drwx-rwx--r-x as
> I would expect using chmod 0775.
>
> I think that PHP-PDO is a clumsy implementation.
>
> *Ben Marchbanks*
>
> www.magazooms.com 
> Signature
> Email: [EMAIL PROTECTED] 
> Phone: (864) 284.9918
>
>
> 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.
>>>
>>> Thanks,
>>> Al
>>>
>>> 
>>>   
>> Just wondering if you resolved this issue - I'm experiencing the same
>> situation. Very simple project, small database in the project folder?
>>
>> Any help appreciated, thanks
>>
>>
>> Phil
>>   
>> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Ben Marchbanks]

Yes I did resolve it using a large hammer -

I just delete the previous sqlite backup file using ulink since for my 
purposes its a total
backup anyway.

It would be good to know how to do incremental changes as an option - 
let me know if you find a solution.

One thing I did notice is that the file permission were set to 
-rwx-rwx-r-x instead of drwx-rwx--r-x as
I would expect using chmod 0775.

I think that PHP-PDO is a clumsy implementation.

*Ben Marchbanks*

www.magazooms.com 
Signature
Email: [EMAIL PROTECTED] 
Phone: (864) 284.9918


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.
>>
>> Thanks,
>> Al
>>
>> 
>
> Just wondering if you resolved this issue - I'm experiencing the same
> situation. Very simple project, small database in the project folder?
>
> Any help appreciated, thanks
>
>
> Phil
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[D. Richard Hipp]

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

Re: [sqlite] Adobe AIR Version Issue(?)

[phillipm]

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.
> 
> Thanks,
> Al
> 

Just wondering if you resolved this issue - I'm experiencing the same
situation. Very simple project, small database in the project folder?

Any help appreciated, thanks


Phil
-- 
View this message in context: 
http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p20635635.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[tiggyboo]

Dennis Cote-2 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.
>>
>>   
> It is more likely that you are simply opening a different database, 
> either a different file, a temp file, or an in memory database. In the 
> shell you can enter the command .database at the prompt. The shell will 
> display the path to the file it has open. Ensure this is the same file 
> you are opening in Air.
> 
> You can check the version of sqlite running in Air by executing the 
> following query:
> 
> select sqlite_version();
> 
> HTH
> Dennis Cote
> 
> Many thanks, that was the issue precisely.  What a luxury now to be able
> to turn my attention to content specifics!  Thanks again,
> Al
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p16518053.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR Version Issue(?)

[Dennis Cote]

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.
>
>   
It is more likely that you are simply opening a different database, 
either a different file, a temp file, or an in memory database. In the 
shell you can enter the command .database at the prompt. The shell will 
display the path to the file it has open. Ensure this is the same file 
you are opening in Air.

You can check the version of sqlite running in Air by executing the 
following query:

select sqlite_version();

HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users