Hi,
additionally to what David wrote: I usually use a descriptive name + SYS(2015) for temp. tables or cursors. This ensures the uniqueness and readability:
_ap1name = "mytab1" + SYS(2015) + '.TMP'
_ap2name = "mytab2" + SYS(2015) + '.TMP'
Armin
>Hi
>Trying to create two temporary tables with this bit if code.
>
> _ap1name = Sys(3) + '.TMP'
> _ap2name = Sys(3) + '.TMP'
>
> Create Table (_ap1name) (dbfname C(15))
> Index On dbfname Tag dbfname
> Use
>
> Create Table (_ap2name) (dbfname C(15))
> Index On dbfname Tag dbfname
> Append From Array a_files
> Release a_files
> Use
>
> Select 0
> Use (_ap2name) Alias _ap2 Order dbfname Excl
>
> Select 0
> Use (_ap1name) Alias _ap1 Order dbfname Excl
>
>Problem is that when it gets to the last line I get an error message saying that the table is already in use. It seems to be confusing the two tables.
>
>Any help greatly apprectiated.
>
>Phil