Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Random search in a table
Message
De
09/12/2004 11:12:46
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00968006
Message ID:
00968032
Vues:
9
>What about something similar to this:
>
>
>SELECT  TOP 3 *, INT(1000*RAND()) as _order from (your_table) ORDER BY _order
>
>
Hey Yuri.. Thanks for your repli

Nice one.. But, Jim gave me one more applicable for my needs..

Because the amount of data it is very big.. Will be something as 600.000 of 1.800.000

So the binary search will turn the query faster..

On every record I'll just record a date and some mark (this is other reason of all that I must to do is SEEK)

Thanks again..

Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform