Is it possible for a script to return a "table", such that it could be called from SQL using the TABLE CALL syntax?
I have a directory structure of files, which I would like to query, joining to data within other tables inside my Manifold 9 project.
I've got IronPython scripts that return strings, which is easy enough. What I can't figure out is how to return a "table" where the script has produced, for example, a list, or a dict. Ideally, I'd call it as
FUNCTION dir_list(@root NVARCHAR) TABLE AS SCRIPT [drive_scripts] ENTRY 'DirList';
TABLE CALL dir_list('c:\\my files\\')
Each row in the CALLed dir_list() table is a list element that has been produced within the script.
I'm unclear on the syntax for converting a python list (or dict?) into a "table" object. Any pointers are very much appreciated. Thank you.