Hi all,

I have the following code

IF !USED("mytable")
USE c:\mydir\mytable.dbf ALIAS mytable
ENDIF
SELECT mytable
GO TOP
DO WHILE !EOF()
IF !USED("mytable2")
USE c:\mydir\mytable2.dbf ALIAS mytable2
ENDIF
REPLACE mytable.field1 WITH mytable2.field1
SELECT mytable
IF !EOF()
SKIP
ENDIF
ENDDO

But as soon as I open mytable2 the ALIAS mytable cannot be found.

Why is this ?