>* 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) >>
>WHERE (lcFExpend).fieldname="myvalue" >There are several ways out. First, since its name is rather random, you may not like to use it - use the alias instead:
WHERE aex.fieldname="myvalue"In any other case, you may either
select (lcFexpAlias)
oruse (lcFExpend) again in 0 alias FExpendand refer to its fields with FExpend.fieldname wherever you need it.