>Yes, the help says that if the return value is more than 1, it represents the number of "result sets" returned. But it looks pretty kludgy to get more than 1 result back from a single SQLEXEC(). Have you ever needed to do that?
Between six and twenty, for big batch jobs. I actually made it a bit more flexible by including a special field in the beginning of each, so I would have meaningful aliases for them:
select '+' as crsMyCursorName, ....fields...
then I'd have a realias() function which would do this
tcTo = EVL(tcTo, FIELD(1, tcFrom))
IF USED(tcFrom)
USE IN SELECT(tcTo)
USE DBF(tcFrom) IN 0 ALIAS (tcTo) AGAIN
USE IN SELECT(tcFrom)
ENDIF