>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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 haven't had time to digest the entire post, but one item immediately stood out -- while you can SEEK in another work area, the FOUND() function is specific to the current work area. So, if the last seek, locate, etc. against the current table failed, found() will remain False, even if the seek you wrote succeeds. A better approach would be this:
if Seek(mkey, "MyTable", "TUE2TVD")
endif
Again, that may or may not be the problem... either way, it's a lurking potential-problem.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell