>All,
>
>On this client we have now proved the following code (snippet) works
>
>select aliasname
>if used("aliasname")
>select
>end if
>
> ...... other stuff
>
>BUT
>
>select aliasname
>
> ...... other stuff
>
>ends up selecting the wrong database.
>
>Does anyone have any ideas?
>
Can you give some examples of the alias names and table names. BTW, you are referring to tables as databases!?!
What is the name of the table and alias you are selecting?
What is the name of the table being selected?
Is the table being selected the one already in the current work area when you try to select?