Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Random quote for the day..
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01394387
Message ID:
01394426
Views:
38
>>>In VFP I would assume we would need
>>>
>>>rand(-1)
>>>
>>>select top * from ( select *, rand() as Rec from myTable) Derived order by Rec
>>>
>>>but this looks like very inefficient method and I would use the technique Sergey described instead, however, I'm not exactly sure how would it work in case of deleted records.
>>
>>Deleted records in quote of the day table? :-)
>>There are none.
>
>But what if we have deleted records there for some reason?

Then you PACK the table before you redistribute it to the customers :-)
That is an internal table so you could do whatever you want with it :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform