B4J Question [BANano] What is the best way to deal with inner and outer BANanoSQL.ExecuteWait?

Mashiane

Expert
Licensed User
Longtime User
Ola

Id like to use the result on the inner BANanoSQL.ExecuteWait in the outer BANAnoSQL.ExecuteWait?

Hypothetically...

B4X:
dim json1 as list = db.ExecuteWait(query,args)
for each rec1 as map in json1
    dim query1 as string = rec1.get("query")
    dim args1 as list = rec1.get("args")
    dim json2 as list = db.ExecuteWait(query1, args1)
    for each rec2 as map in json2
        'do whatever
    next
next

Thanks
 
Top