>i tried USE in form load in shared mode
>
>and then i later also tried putting them in the data environment.
>
>in both cases i had the same problem.
>
>However i was able to solve the problem in a way which i want to avoid
>
>I did scan endscan and replaced a dummy field with a blank.
>
>this i did just before executing the Select statement.
>
>this seems to have solved the problem as far as the user is concerned but this approach seems to be a temporary solution to me at the best.
That's strange indeed. Are you sure that the right tables (in the correct directory) are picked up?
If it's not broken, fix it until it is.
My Blog