>What Nadya said about LOOKUP(),

I don't see how that will help at all.

>but one of your problems here may be that SET EXCLUSIVE is scoped to the DataSession (see the help under SET DATASESSION for a full list of commands.

Then it sould always fail, shouldn't it?


>(Do you want to call the variable loNewDS, btw?)

Yes I will.


>Also, you might want to write your search as follows -- mileage may vary, of course.
>
>

SELECT 0
>USE people SHARED
>IF SEEK(tcEmpNo, "people", "empNo")
>*!* etc.

The code posted is not exactly what we use, we have another function that opens tables, I thought I'll post code that emphasize the intended function.

The main question was/is related to the use of the datasession.

Thanks,
dz