How do i loop thru the subfolders? Also I would like to list the tables in the folders...?
this is the code I have so far...
var db = HostApp.getDatabase();
var objects = db.getObjects("USERS/SGLANV01")
for (var i = 0; i < objects.length; ++i)
//if (objects[i].type != "TABLE")
alert(objects[i].type + ";" + objects[i].name);
//SQL piece would go in here