>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 >>
>>CREATE TABLE test (testfld c(10)) >> >>USE >> >>USE test ALIAS atest >> >>SELECT * FROM atest INTO CURSOR qtest >> >>select test >> >>Is it because Sql reads from disk and takes the original table name ? and is it the same behavior with VFP9 with buffering = .t. ??