Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create dummy name for table?
Message
From
18/04/2000 17:43:23
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00361033
Message ID:
00361070
Views:
20
I assume you want to use a table so that it can be updated during the process. If so, try this:
vc=sys(2015)
SELECT (your select code) INTO table (vc)
if _tally=0
=messagebox('There are no customers that match this criterion...')
use in vc
todelete=vc+'.dbf'
delete file &todelete
return
endif
use (vc) again in 0 alias MyAliasName

This will give you diff tables for each user but the code all refers to whatever alias you use. Be sure to delete the file when you finish.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Previous
Reply
Map
View

Click here to load this message in the networking platform