Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Subquery
Message
 
À
29/11/1999 12:36:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00296400
Message ID:
00296441
Vues:
27
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform