>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

Are the filenames unique - Help file says that "sys(3) may return non-unique name when issued successionally on a fast computer".