how do you catch sql errors when using ext-air wrappers?
I have some data that I am inserting into my local SQLite database via the proxy (proxy.insert(data)) bypassing the store. Obviously every thing works fine as long as the data is as the corresponding table expects it (eg. text for TEXT, integers for INTEGER, etc..) but when the data is wrong for the expected data type the AIR application throws an SQLErrorEvent as follows:
So I put in an Event Listener for SQLErrorEvent attached to the Air.Connection object named for this example airConn:
SQLError: 'Error #3132: Data type mismatch.', details:'could not convert text value to numeric value.', operation:'execute', detailID:'2300'
And this is where I am running into a problem:
//error handling stuff here.
The reason I am posing this here is that I am using the ext-air wrappers for all my SQL calls and table manipulations. obviously the way I am doing this is wrong, how is it that I need to set up my listeners to catch these errors????
TypeError: Value undefined does not allow function calls.