Hi,

how to get only buffered records ?

Create Cursor abcd (abc C(10))
insert into abcd values('xyz')
cursorsetprop("buffering",5)
insert into abcd values('xyz1')
insert into abcd values('xyz2')
select * from abcd with (buffering = .t.) into cursor test
?"records returned from buffer : " + Transform(_tally)
select * from abcd into cursor test
?"records returned from Disk : " + Transform(_tally)

* now how to return only buffered records ?????
* tried the following..

Select * from abcd ;
where (select Recno() as nrecno  from abcd with (buffering = .t.)) not in ;
(select Recno() as nrecno  from abcd)  && Sql : invalid use of subquery

Select b1.* from ;
(select * from abcd a1 with (buffering = .t.) where a1.recno() not in ;
(select b1.recno() from abcd b1)) as b1 into cursor test1 && SQL : Queries of this type are not supported.

How to acomplish the same? and wouldnt it be better if a function would be avaiable like
Now that buffered records are accessible it would be used more and more

with (buffering = 0) --- from disk
with (buffering = 1 ) --- buffered records reads from buffered alias
with (buffering = 2 ) --- only buffered records from the alias

Or is there one avaiable already ?

Suhas