To avoid the BROWSE, I use:
... into cursor Temp. I am not accustomed to the syntax suggested by Sergey; I am not sure whether it already works in VFP 6, which I currently use.
>Hi Fox maniacs
>
>I have the below select command. All I'm interested in is the _TALLY so I throw the results away. I'm doing several of these in a loop. Proble is the "NOCONSOLE" clause seems to be ignored and I'm getting every result set up in a browse window.
>
>The source csrInterim, by the way, is a cursor created via a Select ... ReadWrite. Would this have any bearing? Don't see why.
>
>'ppreciate it.
>
>Terry
>
>
> SELECT RZSTOP.* ;
> FROM csrInterim ;
> LEFT OUTER JOIN mclmpser!RZSTOP ;
> ON csrInterim.rte_no == RZSTOP.rte_no ;
> AND csrInterim.rte_let == RZSTOP.rte_let ;
> AND csrInterim.directn == RZSTOP.directn ;
> AND csrInterim.seqno == RZSTOP.seqno ;
> WHERE csrInterim.rte_no == lcRteNo ;
> AND csrInterim.rte_let == lcRteLet ;
> AND csrInterim.directn == lcDirectn ;
> AND csrInterim.var_code == lcVarCode ;
> AND csrInterim.SeqNo == lnSeqNo ;
> NOCONSOLE
>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)