Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subquery
Message
From
29/11/1999 13:13:57
 
 
To
29/11/1999 12:36:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00296400
Message ID:
00296459
Views:
17
>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?

NOCONSOLE is a REPORT FORM directive, not an SQL directive.

YOu need to assign the results of your query to a cursor:

SELECT Whatever FROM Whatever INTO CURSOR MyCursor

Then your report fields should be looking at MyCursor.Whatever
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform