Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Random quote for the day..
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01394387
Message ID:
01394426
Vues:
39
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform