How to manage multiple SQL variables

In all of the B4A examples I've seen with SQLite, the app uses a global variable SQL1 that is initialized when the app is started/resumed. This is fine.

But if the app has a lot of nested Subs that need SQL access to tables, they can't all reference the same global SQL1 variable because it may already have a cursor open in another Sub. For example, Sub1 may be looping through Table1 and inside the loop it calls Sub2 that needs to do a lookup to Table2 and also calls Sub3 that updates rows...

How to manage multiple SQL variables

from B4X Community - Android, iOS, desktop, server and IoT programming tools http://ift.tt/29bwfpY
via IFTTT