Get a record with the latest Date

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Get a record with the latest Date

Message

04/12/2000 12:10:15

Stephane Hamel
Transfugesoft Inc..
Lachenaie, Québec, Canada

04/12/2000 12:02:36

Chris McCandless
Red Sky Software
Louisville, Kentucky, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: Get a record with the latest Date

Divers

Thread ID:

00448872

Message ID:

00448886

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform