Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid database table name error
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Invalid database table name error
Miscellaneous
Thread ID:
00368813
Message ID:
00368813
Views:
66
I am using a varible that contains the name of a table. Using the drop table command, I get the an error stating 'invalid database table name'. Isn't it possible to delete table based on variable names? Here is the code:

&&cmdcreatetable this create random name table
ranvar = sys(2015)
.ranvar = ranvar
SELECT test FROM employee!employee into table (ranvar)


&&cmddeletetable this is suppose to delete random name table
ranvar = .ranvar
drop table (ranvar+'.dbf')


Thanks
Nick Patel
Next
Reply
Map
View

Click here to load this message in the networking platform