Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting by a DateTime type
Message
De
30/05/1996 03:02:56
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00001725
Message ID:
00001791
Vues:
40
>SELECT rollview.barcode AS bar, rollview.accept AS
>acc, convert(VARCHAR(12),rollview.orgdate) AS org
>FROM rollview ORDER org DESC, acc DESC, bar ASC
>INTO CURSOR temp
>
>This gave me a syntax error. I'm thinking VFP
>doesn't like the convert().

sorry - i didn't notice the convert()
there is no such function in VFP - try DTOS instead
and if u nead the time portion as well use Hour(),Minute()
and Sec() to get thier values as well (btw all 3 return
numeric values )

Arnon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform