Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT-SQL, DATE() and DATETIME()
Message
De
31/05/2003 10:35:05
 
 
À
31/05/2003 10:03:45
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00794631
Message ID:
00794867
Vues:
18
Cetin,

own problem is not on the time when the SELECT start, but while the SELECT execute, DATETIME() change, and this change is usefull to you.

The process of call DATETIME() is random for the first call, but all next call are correlate with this first event;
for remove this, is need that the execution process have a white spectre.

For get 5 randomly picked customers, you need SELECT duration is more 5 seconds, and implement one randomization function RANDOM(DATETIME()).

The naturally function for do this task is RAND() function.

I need one exclusive example, that is one SELECT impossible to implement without the DATETIME() dinamically variations.

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

Click here to load this message in the networking platform