Close all
Create Cursor abcd (abc C(10))
insert into abcd values('xyz')
insert into abcd values('xyz1')
cursorsetprop("buffering",5)
insert into abcd values('xyz2')
insert into abcd values('xyz3')
replace abc WITH 'xyz4' FOR abc='xyz1'
Select 0
select * from abcd with (buffering = .t.) WHERE "2" $ GETFLDSTATE(-1)+LEFT(abc,0) into cursor query
Use in query
select * from abcd with (buffering = .t.) WHERE "2" $ GETFLDSTATE(-1)+LEFT(abc,0) into cursor query && error "alias not found "

Any ideas

suhas


this is simple,
the rule for empty workarea is valid only if it is THE FIRST EMPTY WORKAREA.
then at WHERE PARSING phase it use the empty workarea,
and GETFLDSTATE() fire this error for a empty WA.

CLEAR
CLOSE DATABASES ALL
CLOSE TABLES all
ON ERROR ? MESSAGE()
SET MULTILOCKS ON
Create Cursor abcd (abc C(10))
insert into abcd values('xyz')
insert into abcd values('xyz1')
cursorsetprop("buffering",5)
insert into abcd values('xyz2')
insert into abcd values('xyz3')
replace abc WITH 'xyz4' FOR abc='xyz1'
Select 0
select * from abcd with (buffering = .t.) WHERE "2" $ GETFLDSTATE(-1) into cursor query
USE
Select 100 && not first empty WA fire the error
? SELECT(0),"is empty",ALIAS()
select * from abcd with (buffering = .t.) WHERE "2" $ GETFLDSTATE(-1) into cursor query 
Select 2   && this not fire the error
? SELECT(0),"is empty",ALIAS()
select * from abcd with (buffering = .t.) WHERE "2" $ GETFLDSTATE(-1) into cursor query
ON ERROR