Neil
I think it's that VFP doesn't like a numeric value for an alias, or a numeric string, AND that you're trying to macro-sub a numeric
How about
lcAlias = "A" + ALLTTRIM( STR( lnCount))
USE vwmmembership IN 0 ALIAS ( lcAlias) again
e.g. aliases of "A1", "A2" etc.
Terry
>I am trying to open a table up a number of times dependant on how many records are in a table named vwmactionnot. The problem is it is not substituting the alias name for lncount. Any ideas waht I am doing wrong?
>
>
>lncount = 1
>DO WHILE vwmactionnot.actionno = 1
> USE vwmmembership IN 0 ALIAS &lncount again
> SELECT lncount
> SET ORDER TO username
> BROWSE NOINIT nowait
> lncount = lncount + 1
> SKIP
>ENDDO
>
- 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.
