loop thru subfolders

[abenitez77]

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")

Console.write(objects.length)

for (var i = 0; i < objects.length; ++i)
{
//if (objects[i].type != "TABLE")
//continue;
alert(objects[i].type + ";" + objects[i].name);
//SQL piece would go in here
}