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 > >