A simple function I need does not exist in the SQLite engine core but the SQLite gurus are telling me to write my own function in C and load it at runtime as a "loadable extension". (I have good reasons, BTW, for not wanting the function to execute in the client--it really belongs in the back-end.)
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions The LoadableExtensions mechanism is disabled by default, and Adobe in its implementation of SQLite may not have enabled the LoadableExtensions mechanism; or if it is enabled, a developer does not know whether it is "officially" enabled or an undocumented use-at-your-own-risk feature. Where would one get an official answer to the LoadableExtension supported/not-supported question? I've tried the AIR forum at Adobe but my question was not answered there. Thanks