Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compound index with date field.
Message
From
18/01/2005 10:33:53
Sylvain Larin
Montréal, Quebec, Canada
 
 
To
18/01/2005 10:26:47
Dean Hanson
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Compound index with date field.
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00978097
Message ID:
00978102
Views:
24
DTOC () without the second parameter is dependant of the SET DATE and SET CENTURY settings wich could lead to out of order records if a user with a different settings update the records. DTOC (, 1) or DTOS () return the same date format suitable for indexing (YYYYMMDD).

HTH

>Is there an advantage of using DTOS() over DTOC() or vise-versa when creating a compound index with a date field?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform