Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Filter Performs Unwanted Transformation
Message
De
22/09/2000 01:15:35
 
 
À
12/09/2000 17:34:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00415571
Message ID:
00419548
Vues:
10
>I'm resetting a filter with a date literal and it suddenly became... AMBIGUOUS!

I'd suggest using a CTOD() on an index and then filtering on that. There's another reason too, sometimes doing a seek on a datetime will fail, and you don't know why. Its because the DateTime actually store the millisecond in the table, but its not possible to specify the millisecond in a variable, so the seek rarely finds a match, even though one should exist. CTOT() solves that.

By the way, I liked Larry's suggestion, its pretty sneaky!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform