Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Funny: When a equal can to be not equal
Message
 
 
To
11/04/2005 13:16:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01003001
Message ID:
01003449
Views:
22
Fabio,

>INDEX RAND() TAG T_RAND

rand() is quite different than datetime() because each row will have a distinct value subject to the limits of the pseudorandom number generator.

>With DATE()/DATETIME() is possible do more complex operations.

Like what? You are creating several keys with the same value so the usefulness of your complex operations seems somewhat suspect. Such an index would be no different than the natural order of the table.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform