Hello, I am curious if anyone else has experience with the FlexCubed
product, FlexSQL. I have found it to be a very useful component,
however, I don't feel like I am using it under best practices. I feel
like the event listeners are a little awkward, and I don't like the
thought of instantiating a new flexsql object for every query. It seems
like there should be a better way of handling the "flexsqlcomplete"
event listener for simultanious queries.
The process that I use is:
1. Instantiate FlexSQL
1. Associate an Event Listner for QueryComplete
2. Associate an Event Listner for Error/Fault
3. Define an function that handles the executequery SQL string
1. I set a variable that handles that references the function name
2. Within the Event listener for QueryComplete, I check for the
string variable of the function and perform processing on the results.
In a simultaneous query situation, I have found that managing the
ordering of the querys is quite important as some queries that take
longer will over-write the xmlData segment.
I would be very interested to hear how others are doing it.
Thanks
