I'm like *really* confused about macro expansions and name expressions. I start with the following code:

* Grab a couple tempfile names

lcFOrange= SUBSTR(SYS(2015), 3, 10) && taken from VFP help examples
lcFExpend =SUBSTR(SYS(2015), 3, 10) && temp table name
lcFCommit =SUBSTR(SYS(2015), 3, 10) && temp table name
lcFOutput =SUBSTR(SYS(2015), 3, 10) && temp output file

SELECT whatever into table (lcFExpend)

This works, fine, but the (lcFExpend) then isn't a "real" alias that can be used to do things like

WHERE (lcFExpend).fieldname="myvalue"

I fooled around with all combinations of &lcFExpend and (lcFexpend) and sometimes things seem to work and other times not.

I guess my global question is, how can I use a temporary file name that is randomly generated, for a table name within a program, and then be able to delete the file name. I'd like the name to be random; (it is a multi-user program). And I need to use this the same way I would use a normal table alias.

Thanks.

--- Larry