Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search for datetime
Message
 
À
31/08/2005 07:53:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01045440
Message ID:
01045450
Vues:
26
If you do not have the index on this field, then you may use locate command, like:
locate for between(...)
*or 
locate for datetime>... and datetime <...
Otherwise:
set order to ...
set near on   && even not found, the cursor will be at the nearest match.
?seek(...)
>Hi,
>I'd like to find a datetime field in a table which is the nearest to a certain given datetime. What functions can be used? And Any idea would be appreciated.
>

>Thanks
>
>Tamas Szigeti
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform