Hi Peter,
PMFJI, instead of the NOCONSOLE you need to direct the query to a cursor i.e. INTO CURSOR csrResult. This will suppress the browse window.
>Thanks. I knew it would be something simple. Now my code reads SELECT red,yellow,blue from MainTable NOCONSOLE;
>WHERE orange IN (SELECT orange FROM cursor2)...but the NOCONSOLE is not working. This query is designed to go directly to a report, which it does nicely, but before it does this browse window opens. Why doesn't the NOCONSOLE supress it?
HTH,
Bill Armbrecht
VFP MCP