Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Top
Message
From
13/01/2000 04:58:30
 
 
To
13/01/2000 04:51:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00317437
Message ID:
00317438
Views:
25
The query designer generates a SQL command. The TOP clause is part of the SQL Select command syntax.

The following is a simple example of its use:

select * TOP 10 ;
from MyTable ;
into cursor MyCursor

OR

select * TOP 10 PERCENT;
from MyTable ;
into cursor MyCursor

If you select Query->View SQL from the FoxPro menu when the query designer is running then you can see exactly the effect the interface objects/selections have on the code.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform