Hi Carlos,
IMHO knows bug in VFP 9.0 SP 2
You can change index expression to (add space after date/datetime)
ALLTR(TTOC(MiFechaHora, 1))<b>+" "+</b>ALLTRIM (str (NumberOfCustomer))
but better index expression is
TTOC(MiFechaHora, 1)<b>+" "+</b>PADL(NumberOfCustomer,17,"0")
MartinaJ
>To avoid index corruption on win 7 on Intel Core I 7: I had to do the following:
>Avoid the use of indexes that use functions:
>I use text fields containing information for management.
>if I need to sort by Date-Time + Number of client I use an extra field previously converted string type:
>
>MiField = ALLTRIM (TTOC (MiFechaHora, 1)) + ALLTRIM (str (NumberOfCustomer))
>
>I avoid using indexes using date field, but instead created an extra field of type characterss and store the value of the date conversion (DTOC (Date))
>
>
>I run my executable file in admin mode and compatibility mode Win XP SP3, to avoid conflicts with Virtual Store and the Roamming of Win 7.
>
>
>
>regards