*-- bookmark selected area >lcSelect = ALIAS() > >*-- Execute a Sql Select that opens one or more tables >*** select * from mytable1 join mytable2 .. join mytable3.. etc. > >lnOpenDbfs = AUSED(laArr) > >FOR lnLoop = 1 TO m.lnOpenDbfs > > IF m.laArr[m.lnLoop,1] = m.lcSelect > LOOP > ENDIF > > USE IN (m.laArr(m.lnLoop,1)) >NEXT>
>>*-- bookmark selected area >>nSelect = select() >> >>*-- Execute a Sql Select that opens one or more tables >>select * from mytable1 join mytable2 .. join mytable3.. etc. >> >>*-- Close all tables opened in the above SQL Select. >> >>*-- I believe I need to know the highest SELECT() at this >>point and scan it backwards until coming to nSelect. >>But how to determine currently highest SELECT()? >> >>>>