Clever!

Glenn

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