SQL UPDATE bug?

Solar2D General Questions/Discussion
#1

As a test I have this in my main.lua file:

display.setStatusBar( display.HiddenStatusBar )  
  
require("sqlite3")  
  
db = sqlite3.open( system.pathForFile("data.db", system.ResourceDirectory) )  
  
db:exec( 'UPDATE user SET highscore=1 WHERE id=1')  
  
print('update happened')

This causes the simulator to “flash” and this gets produced in the console:

Copyright (C) 2009-2010 A n s c a , I n c .  
 Version: 2.0.0  
 Build: 2011.484  
The file sandbox for this project is located at the following folder:  
 (/Users/davidchiu/Library/Application Support/Corona Simulator/.-4399E3845050BA4901EE6EB7884E6E63)  
  
Copyright (C) 2009-2010 A n s c a , I n c .  
 Version: 2.0.0  
 Build: 2011.484  
The file sandbox for this project is located at the following folder:  
 (/Users/davidchiu/Library/Application Support/Corona Simulator/.-4399E3845050BA4901EE6EB7884E6E63)  
update happened  
  
Copyright (C) 2009-2010 A n s c a , I n c .  
 Version: 2.0.0  
 Build: 2011.484  
The file sandbox for this project is located at the following folder:  
 (/Users/davidchiu/Library/Application Support/Corona Simulator/.-4399E3845050BA4901EE6EB7884E6E63)  
update happened

The SQL update is causing the simulator to reboot (it appears). This is causing my game to crash (using director.lua). Is this a bug in the SQL Lite lib?
[import]uid: 23583 topic_id: 12216 reply_id: 312216[/import]

#2

FIGURED IT OUT!!!

I had copied my data.db file to my project directory for deployment and testing on my iPhone. In the Corona Simulator -> Preferences there is an option to “Relaunch Simulator when project is modified?”. This setting is set to “Always” be default. Since a SQL UPDATE modifies the data.db file, this caused the simulator to restart itself. Changing this setting to “Never” resolved the problem! [import]uid: 23583 topic_id: 12216 reply_id: 44480[/import]