Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Random search in a table
Message
From
09/12/2004 11:12:46
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00968006
Message ID:
00968032
Views:
10
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform