MikeA
Tue May 13 14:27:39 CDT 2008
Rush is right and to clarify:
use in (select("test"))
will NEVER throw an error.
But,
USE Test IN SELECT("Test")
will if test is already used exclusively on another machine.
So you just do something like:
on error m.llErr = .t.
USE Test IN SELECT("Test")
if m.llErr
messagebox("File could not be opened, try again later")
return
endif
One other thing:
if one does this:
USE Test IN SELECT("Test")
then you may still have to do a:
Select test
since you may be opening the table in a different work area than the active
one.
Mike
"Rush Strong" <rpstrong@gmail.com> wrote in message
news:67kWj.10040$jk1.2870@trndny05...
> No error.
> USE IN Test
>
> will throw an error if Test is not open, but:
>
> SELECT("Test")
> returns a zero if Test is not found. Thus;
>
> USE IN SELECT("Test")
>
> becomes the equivalent of:
>
> USE IN 0
>
> which would close the table that is open in the first unused work area -
> which, by definition, isn't.
>
> BTW, if you just want the table open (but not necessarily selected) you
> can condense it to:
>
> USE Test IN SELECT("Test")
>
> - Rush
>
> TonySper wrote:
>> Mike,
>> That's neat. I like it. All I wanted to do was see if it was open. If so
>> just select it, if not open it and select it. Your way may create an
>> error if it is not open when you try use in!!
>> TonySper
>>
>> "MikeA" <appell@appellsoftware.com> wrote in message
>> news:M09Wj.7135$Uz2.5810@trnddc06...
>>
>>> I think part of this is going to depend on exactly what he his trying to
>>> do and why. If you just want to open the table in a work area one can
>>> easily just close it first and then open the table with any alias like
>>> this:
>>>
>>> use in (select("test"))
>>> use test
>>>
>>> That is a little rudimentary as for my routine I also have an "on error"
>>> to trap if there are errors since it could be used exclusively in
>>> another datasession or on another workstation on a network.
>>>
>>> Mike
>>>
>>> "Olaf Doschke" <olaf.doschke@t-aufderlinie.de> wrote in message
>>> news:3CFF3D0D-D472-49FA-B008-4D73FE5C5FDC@microsoft.com...
>>>
>>>>>>> For m.ii=1 to 255
>>>>>>> select m.ii
>>>>>>>
>>>>> This one should be: select &ii
>>>>>
>>>> No, Select m.ii is just fine.
>>>> Makrosubstitution will not work on numeric variables.
>>>>
>>>> Bye, Olaf.
>>>>
>>>
>>
>>
>>