Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor without index
Message
 
 
À
03/04/2006 14:35:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01110033
Message ID:
01110038
Vues:
12
>it is a good way to do it like that ?????
>
>
>PUBLIC LCDX
>STORE "TMP_"+ SYS(03) TO LCDX
>
>SELECT IDENT,HSCODE,DESC1,DESC2 FROM TB_HS_MESS ;
>WHERE IDCLIENT = l_Custno ORDER BY hscode INTO CURSOR CUR_HSCODE
>INDEX ON HSCODE TAG HSCODE OF &LCDX
>INDEX ON DESC1 TAG DESC1 OF &LCDX

1. Don't use public

See my changes

2.
SELECT IDENT,HSCODE,DESC1,DESC2 FROM TB_HS_MESS ;
WHERE IDCLIENT = l_Custno ORDER BY hscode INTO CURSOR CUR_HSCODE ReadWrite

INDEX ON HSCODE TAG HSCODE 
INDEX ON DESC1 TAG DESC1
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform