Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limiting number of records from ADO queries
Message
 
To
24/02/1999 11:48:44
Jeroen Naus
Harte-Hanks Europe
Hasselt, Belgium
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Limiting number of records from ADO queries
Miscellaneous
Thread ID:
00190989
Message ID:
00191027
Views:
53
>In your sql select you can do "select top 400 ... from ..."

I tried that, and ADO (or ODBC driver) gives me a syntax error. When I look in the DrvVfp.hlp file (comes with VFP ODBC driver), the SELECT command does not support the TOP clause.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform