I have a SQLite file to which I'm connecting. I don't have a safety function to quit the SQL connection if it's taking too long. Can anyone offer a means to do this?
I've tried the following:
_sqlStat is my SQLStatement.
public function timeLongConnectionHandler (e:Event):void
var connectionTimer:Timer = new Timer(1000, 0);
public function skipLongConnectionHandler (e:TimerEvent):void
trace("Connection Delay - DB Data Skipped");
Which throws this error:
Error: Error #3106: Property cannot be changed while SQLStatement.executing is true.
Basically these kind of stuff (SQL Connection time out ) should be done on to the server (For example if i am using JDBC for connection to Database , i wiould set Coonection.setTimeOut(50) ) and these way you would get an SQLException , which we need to handle it through the fault event .
Thanks for the response. The database is a SQLite file. I am currently setting a variable to wait until the connection has attempted to connect to it 50 times and then throwing an error. It's working, but I'd still love to hear if there's a better way. Thanks!