Hi,
I am having alot of trouble saving data to an Sqlite db. I have no
trouble, loading data, however commiting changes permanently seems to
fail.
I am using a delegate for the table. The code to execute any
sqlStatement is:
private function executeSQL(sqlStatement:SQLStatement):void{
if(sqlStatement != null){
sqlStatement.addEventListener(SQLEvent.RESULT, responder.result);
sqlStatement.addEventListener(SQLErrorEvent.ERROR, responder.fault);
sqlStatement.sqlConnection = storyHelperConn;
sqlStatement.execute();
}
}
public function UpdateStory(story:StoryVO):void{
try{
if(!isDBOpen){
openDatabase();
var sqlQuery:String = "update stories set title = :titleText, " +
"where id = :id";
sqlStatement = new SQLStatement();
sqlStatement.text = sqlQuery;
sqlStatement.parameters[":titleText"] = story.title;
sqlStatement.parameters[":id"] = story.id;
sqlStatement.itemClass = StoryVO;
executeSQL(sqlStatement);
}catch(e:Error){
trace("Story Delegate Update Story error: "+e.message + " " +
e.toString());
}
}
The database is stored in src/assets. I get no errors. When debuging i
can view the parameters, and they contain all the correct data.
Ive been pouring over various help sites and tutorials without success.
Can anyone suggest anything to look for? Possible uncaught errors, etc?
Regards,
Beriah