Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get a record with the latest Date
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00448872
Message ID:
00448898
Vues:
14
>>>SELECT TOP 1 *
>>> FROM MyTable
>>> WHERE Product = ?Parm1
>>> ORDER BY ChangedDate DESC
>>
>>When i try this, i am getting
>>
>>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '1'.
>>
>>I am using SPT , Any Idea ?
>
>What version of SQL Server are you using? I am using 7.0, which supports TOP n, but I think I remember reading that 6.x and earlier do not.

Nop, i am using 7.0
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform