Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a View in descending order
Message
 
À
19/03/1999 13:40:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00199835
Message ID:
00200389
Vues:
10
>>Hi,
>>
>>I have a View that I need to index on a character field (type of document) in ascending order and documents of the same type must be indexed on a date field (date of the document) in descending order. In VFP 5.0 I was using INDEX ON tp_documento + STR({31/12/2100} - dt_documento, 5) TAG DATA and it was working fine. After upgradind to VFP 6.0 I needed to change to {^2100-12-31} and now I get a message that says :
>>
>>Index does not match the table. Delete the index file and re-create the index (Error 114)
>>
>>Any help ?
>>
>>Regards,
>
>USE DTOS to convert your date to a date setting independent string.

Erik,
He wants the document type in ascending order and the date in descending order. So he first makes the substraction between a date in the distant future and the document date and obtains a numeral that he converts to string after. That's OK for me, and works well under VFP5.

José
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform