My intent is no multiple batches, i.e., single return of small result sets. The thing is that it was working for months and some setting must have changed. I'll do a brute force trying of settings and get it back. What I sometimes find is that I had something working by accident without really understanding the interplay or that I understood the interplay of settings and said "That's so obvious there's no need to document it, how could anyone ever forget?" Oops!


>Take a look at SQLMORERESULTS() the VFP docs. You can submit more than one query in a single call to SQLEXEC(). The Batch property controls how the results will come back. They can all come back at one time or you can fetch them one at a time. If you choose the latter, you have to call SQLMORERESULTS() to get each new resultset.
>
>The trick is that you must call SQLMORERESULTS() until it returns a two.
>
>-Mike