Seems the appcelerator docs are wrong again :( the db can't be closed leaving a valid resultset.
Also the db file as not for backup by iOS