Thanks Ross, I was rewriting things along the lines of your example after reading Henrik's reply.
On 4/20/11 2:53 PM, "Ross Sclafani" <[email protected]> wrote: the problem you may run into if you call in a loop is overwriting the object property. i would implement a queue: /////////////// private var statementQueue:Vector.<SQLStatement> = new Vector.<SQLStatement>(); public function getDayOfDrill() : void { var sql:SQLStatement = new SQLStatement(); sql.sqlConnection = _sqlConnection; sql.text = "SELECT dayOfDrill FROM time"; sql.addEventListener(SQLEvent.RESULT, getDayOfDrillResultHandler, false, 0, true); statementQueue.push(sql); sql.execute(); } private function getDayOfDrillResultHandler(e:SQLEvent) : void { var evt:FDataEvent = new FDataEvent(FDataEvent.GET_DAY_OF_DRILL); evt.param = e.target.data[0]; dispatchEvent(evt); statementQueue.splice(statementQueue.indexOf(e.target,1); } ////////////////// On Apr 20, 2011, at 3:43 PM, Henrik Andersson wrote: > Mattheis, Erik (MIN-WSW) skriver: >> 1. The SQLConnection is asynchronous. Is there a possibility the function >> variable "sql" would get garbage collected before the event handler fires? > > It is a local variable. Yes, it is up for garbage collection the instant the > function returns. So if the event happens after that (as you said it will) > then the garbage collection may happen before that. > _______________________________________________ > Flashcoders mailing list > [email protected] > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders _______________________________________________ Flashcoders mailing list [email protected] http://chattyfig.figleaf.com/mailman/listinfo/flashcoders _ _ _ Erik Mattheis | Weber Shandwick P: (952) 346.6610 M: (612) 377.2272 _______________________________________________ Flashcoders mailing list [email protected] http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
