Nadya,
When you create a table/cursor with an alias that is already used, VFP automatically assigns a new alias. Simply store ALIAS() to a memvar for later reference:
SELECT * FROM < Whatever > INTO TABLE c:\temp\Test.dbf
SELECT * FROM < Whatever > INTO TABLE c:\temp\Test.log
lcLogAlias = ALIAS()
SELECT Test
SELECT (lcLogAlias)
HTH
>Hi everybody,
>
>I have a simple problem, but haven't found a simple solution so far. I want to create two files with the same name. One would have DBF extension, another would have LOG extension. Both are tables and I need to use them in the same program. I
>
> select ... into (m.lcNewFile)
> select juststem(m.lcNewFile)
> append from ...
>
> I also do create table free (m.lcNewLogFile) ...
>
> I need to select it and append records into it. How can I distingush them? Is there the only way to close both and re-open under different aliases?
Daniel