Limiting number of records from ADO queries

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Limiting number of records from ADO queries

Message

24/02/1999 12:36:27

Timothy Callahan
US Bankruptcy Court
Indianapolis, Indiana, États-Unis

24/02/1999 11:48:44

Jeroen Naus
Harte-Hanks Europe
Hasselt, Belgique

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Limiting number of records from ADO queries

Divers

Thread ID:

00190989

Message ID:

00191027

Vues:

>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.

Répondre

Fil

Voir

Click here to load this message in the networking platform