Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PC World article
Message
De
02/01/1998 15:07:19
 
 
À
02/01/1998 15:04:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00068464
Message ID:
00068990
Vues:
62
>>Hey, I'm exposing myself to being even less of a FoxPro^H^H^HBase guy than I think...
>>
>>Select area: 1, Database in Use: C:\DBASE\IBM.DBF Alias: IBM
>>
>>Master index file: C:\DBASE\CNAME.IDX Key: UPPER(CNAME)+UPPER(LNAME)+UPPER (ADDR)
>>
>>Index file: C:\DBASE\LNAME.IDX Key: UPPER(LNAME)+UPPER(FNAME)+UPPER(ADDR)
>>
>>
>>Index file: C:\DBASE\ADDR.IDX Key: UPPER(ADDR)+UPPER(LNAME)
>>
>>Index file: C:\DBASE\EXPIRE.IDX Key: RIGHT(DTOC(EXPIRE),2)+LEFT(DTO
>>C(EXPIRE),5)+RIGHT(DTOC(NEW),2)+LEFT(DTOC(NEW),5)+UPPER(LNAME)

If this is run under Visual FoxPro, then you should use Rushmore. Here, you are using a series of IDX instead of one CDX. You will never be able to be Rushmore optimizable with that.

As for the tag, I would not suggest that. You may create the tag like EXPIRE or DTOS(EXPIRE). By that, you won't have any trouble with the century stuff. The tag should be created on the field on not on some parts of it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform