>>Still, has anyone found a one-liner yet that actually works? Was my appraisal of the accepted solution wrong?
>
>It's a two-liner, and IMO it always was so, if not longer: one to open the table, one to select it. This shortie only has the implied check on "is it already open".
I refer to the one-liner:
Use schedule in select('schedule')
(I have the feeling I've seen your promulgating this technique in the past - or it was something very similar)
and my saying:
"Now I've just tried this one
Use schedule in select('schedule')
with 2 tables open:
If SCHEDULE is not open then it's opened and selected - fine.
However, if the other table is selected, then SCHEDULE does not get selected, the other table stays selected."
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.