Well that was my first thought but I thought that if I stated that, some wiseacre would come back and say "according to Help - yadayada it doesn't matter as the USEd table auto becomes selected...", or whatever. So I kept Schtumm. But in my little experiment with the "one-liner" the USEd table DID become selected auto, by default.
>Yes, Sergey corrected that issue with this:
>
>
>IF !USED('Schedule')
> USE Schedule IN 0
>ENDIF
>SELECT Schedule
>
>
>
>>Actually Terry, then you should not select it always, for in the original code you just posted the table is only selected if it is not opened beforehand <g>
>>
>>
>>>
>>>IF !USED('Schedule')
>>> USE Schedule IN 0
>>>ELSE
>>> SELECT Schedule
>>>ENDIF
>>>
>>>
>>>yes, I guess it does matter.
- 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.