Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on integer & date fields
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Index on integer & date fields
Miscellaneous
Thread ID:
00229164
Message ID:
00229166
Views:
15
>Can I create an index based on an integer & a date field? Actually, the integer refers to the primary key (unintelligent) of another table.
>
>Thanks.

Yes, use STR(IntegerField) + DTOS(DateField) as the key for the index
Janis

www.JamesBooth.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform