Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Curses! Don't want browse of my cursors
Message
 
 
À
21/04/2005 08:32:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Oracle
Divers
Thread ID:
01006923
Message ID:
01006924
Vues:
25
It should be
TO SCREEN NOCONSOLE
>
>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	&& 18/04/05 23/12/04 - this should do for just 1 sequence of a var
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform