Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SEEK with a special index
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Using SEEK with a special index
Miscellaneous
Thread ID:
00430273
Message ID:
00430273
Views:
47
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
Next
Reply
Map
View

Click here to load this message in the networking platform