General information
Category:
Coding, syntax & commands
Title:
Temporary tables 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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only