Hi, Bob!

The SELECT-SQL and APPEND FROM are the only two commands which don't work with buffered data!
To solve this problem I use the following very generic construction:

* create an empty structure
lcCursor = SYS( 2015 )
SELECT * FROM DBF( "MyBufferedData" ) WHERE .F. NOFILTER INTO CURSOR ( m.lcCursor ) READWRITE

* copy the data into an array
SELECT ( "MyBufferedData" )
COPY TO ARRAY laMyData

* moving the data into cursor
SELECT ( m.lcCursor )
APPEND FROM ARRAY laMyData

* now you can fire any SQL-SELECT against the m.lcCursor-workarea!
SELECT * FROM ....