Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using SEEK with a special index
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Using SEEK with a special index
Divers
Thread ID:
00430273
Message ID:
00430273
Vues:
48
Hello everybody!

I have a problem using the function SEEK.
I have a table that has an additional index (not the primary index) called TUE2TVD. It contains the following:
ALLTRIM(STR(iges_nr))+cversichnr+ALLTRIM(STR(ivsversion))+ctarslor+ctarid+ALLTRIM(STR(ilfdnran))+ALLTRIM(STR(iversion))+ALLTRIM(STR(bper_nr,16))+ALLTRIM(STR(irvform))
My function in the code gets the following parameters:
iges_nrParam, cversichnrParam, ivsversionParam, iversionParam, ctarslorParam, ctaridParam, ilfdnranParam, bper_nrParam, irvformParam
so I store to a variable this:
public mkey 
mkey = ALLTRIM(STR(iges_nrParam))+ALLTRIM(cversichnrParam)+ALLTRIM(STR(ivsversionParam))+ALLTRIM(ctarslorParam)+ALLTRIM(ctaridParam)+ALLTRIM(STR(ilfdnranParam))+ALLTRIM(STR(iversionParam))+ALLTRIM(STR(bper_nrParam,16))+ALLTRIM(STR(irvformParam))
and then I call the SEEK function like this:
Seek mkey Order TUE2TVD in mytable
I checked all the parameters, I get everything correct.
Also the data is there but when I call the FOUND() function he does not find any data.

I first wanted to use the SELECT/LOCATE function but I must not change the current Dataenvironment in order to get my parameters correctly, so I have to use SEEK.


Can anyone help me? I am very frustrated in a way...

thank you all
Judith
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform