It might be expecting the alias instead of the filename. Try:
drop table (ranvar)
Mark
>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')
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.