On Tue, Nov 15, 2011 at 6:09 PM, BertD <bert.de.spiegela...@telenet.be>wrote:
> > Hello all, > > Question : > > I'm using Adobe Flex 4.5 to make an Air app that uses a local SQLite > database. > I've created this database using SQLite Database Browser: > http://old.nabble.com/file/p32851221/SDB.png > > When i'm working with the db in Flex, i'm able to Query the db I want, but > am unable to "UPDATE" nor "INSERT" ? Is there any off-the-bat reason why > this would be (like read-only setting i cannot find) ? > > Example : > SQLCust.text = "SELECT * FROM CustComTable"; > SQLCust.execute(); > Works great ! > SQLCust.text = "INSERT INTO CustComTable (CustName) > VALUES('TestName');"; > SQLCust.execute(); > returns me an error : > "Error #3125: Unable to open the database file." > Sounds like you do not have write permission on the directory (folder) which is holding the database file. You need this so that SQLite can create the rollback journal needed for your write transaction. > > Any help would be greaty appriciated ! :handshake: > -- > View this message in context: > http://old.nabble.com/Adobe-Air---Using-SQLite-db%2C-cannot-%22UPDATE%22-nor-%22INSERT%22-tp32851221p32851221.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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
