Thank you very much for the code. In your SQL Select statement you are using NOFILTER and INTO CURSOR. I am actually getting the cursor from SQL Server. I am not sure (or don't know how) how to use the NOFILTER and INTO CURSOR in that case. My SQL Select looks like this (simplied)cSqlSelect = "select * from MYCOMPANY where " + cFilterExp
lnResult = SQLEXEC( hCon, cSqlSelect, [qTmp] )
lnBuffering = CURSORGETPROP( [Buffering], "V_COMPANY" )
CURSORSETPROP( [Buffering], 3, "V_COMPANY" )
ZAP IN ( "V_COMPANY" )
CURSORSETPROP( [Buffering], lnBuffering, "V_COMPANY" )
SELECT ( "V_COMPANY" )
APPEND FROM DBF( [qTmp] )
GO TOP IN ( "V_COMPANY" )
