Check the value of _ap1name & _ap2name. They are probably the same value. SYS(3) does not necessarily give you a unique value. Can you use Create Cursor instead of Create Table or use SYS(2015) instead of SYS(3).

Let me know if this solves your problem.


>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