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

2008-12-06 Thread 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

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

2008-12-06 Thread 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

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

2008-11-26 Thread 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: > >>

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

2008-11-26 Thread 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

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

2008-11-22 Thread 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

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

2008-11-22 Thread 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

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

2008-11-22 Thread 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

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

2008-11-22 Thread 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

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

2008-11-22 Thread 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

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

2008-04-05 Thread 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

[sqlite] Adobe AIR Version Issue(?)

2008-04-05 Thread tiggyboo
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: