It may make little REAL difference, but the SELECT statement you show does not have a semicolon at the end, but the INSERT statement does. Perhaps the error returned is misleading?
-- George Eckert On Tuesday, November 15, 2011 at 6:09 PM, BertD 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." > > 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 (http://Nabble.com). > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org (mailto: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
