When trying to get results from query as XML-formatted string the runtime error is thrown - probably by underlying implementation. The current execution flow is broken unless surrounded with try/catch block as in below example:

var resultsAsXmlString:* = undefined; // untyped
try{
resultsAsXmlString = mdm.Database.SQLite.getXML();
debug(resultsAsXmlString);
} catch(e:Error)
{
debug("runtime error when calling getXML()");
debug(mx.utils.ObjectUtil.toString(e));
}


To recreate issue:
- compile provided project and sample flash movie.
- run native appliaction

Expected output from running application:

initApp()
open()
CREATE TABLE IF NOT EXISTS MyTable(one varchar(10), two smallint);
INSERT INTO MyTable VALUES('hello!',10);
SELECT * FROM MyTable;
hello!,10



hello!
10


close()

(that is it includes XML formatted results)
while current output is:

initApp()
open()
CREATE TABLE IF NOT EXISTS MyTable(one varchar(10), two smallint);
INSERT INTO MyTable VALUES('hello!',10);
SELECT * FROM MyTable;
hello!,10
runtime error when calling getXML()
(TypeError)#0
errorID = 1090
message = "Error #1090"
name = "TypeError"
close()


The issue is similar to that one also related to getXML() method in mdm.Database:
http://www.multidmedia.com/support/bugs/?action=detail&id=246