Kirix Support Forums

loop thru subfolders

Please post any help questions, requests or other feedback here.

loop thru subfolders

Postby abenitez77 on Fri Jun 24, 2016 7:03 am

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
}
abenitez77
Registered User
 
Posts: 143
Joined: Fri Jan 21, 2011 12:42 pm

Return to Strata Help & Feedback