VFP does open table test during query execution but it gets closed after query is completed. You can see it by running following code

CREATE TABLE test (testfld c(10))
USE
USE test ALIAS atest
SELECT *, UdfSusp() FROM atest INTO CURSOR qtest 

RETURN

FUNCTION UdfSusp
SET
SUSPEND
RETURN SPACE(1)

To get result you want, create cursor test beforehand to prevent VFP from opening table test with alias test.

CREATE TABLE test (testfld c(10))
USE
USE test ALIAS atest
CREATE CURSOR test (DUMMY C(1))
SELECT * FROM atest INTO CURSOR test

>Try that code. The last line will give error. Because test table opened with "use test alias atest" command, so VFP won't open an alias for test table when running select command. If VFP don't open remotely test table aliased "test" why SELECT * FROM atest INTO CURSOR test command gives error?
>
>
>

>CREATE TABLE test (testfld c(10))
>
>USE
>
>USE test ALIAS atest
>
>SELECT * FROM atest INTO CURSOR qtest
>
>select test
>
>