Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporary tables problem
Message
From
16/12/2002 11:34:58
Philip Jones
Cornwall County Council
Truro, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Temporary tables problem
Miscellaneous
Thread ID:
00733304
Message ID:
00733304
Views:
49
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
Map
View

Click here to load this message in the networking platform