Select problem - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Select problem

Message

18/04/2007 15:23:52

Olaf Doschke
Setmics
Hamburg, Allemagne

16/04/2007 12:02:01

Agnes Lee
Hong Kong, Hong Kong

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: Select problem

Divers

Thread ID:

01216288

Message ID:

01217447

Vues:

? "SHA/AI/010/04/2006" > "SHA/AI/004/03/2007"
? "SHA/AI/010/04/2006" < "SHA/AI/013/03/2007"

You may read it as some prefix with a date, but you are making string comparisons. There is a reason why DTOS() has the format "YYYYMMDD" and not "DDMMYYYY".

Store all your values as ".../YYYY/MM/DD" and you will be fine.

Bye, Olaf.

Répondre

Fil

Voir

Click here to load this message in the networking platform