>
The approach with zapping the cursor won't work. This is a buffered cursor and you can't zap it.>
>Yes it will:
>
>
>SELECT SomeFields WHERE SomeCondition INTO CURSOR qTmp NOFILTER
>lnBuffering = CURSORGETPROP( [Buffering], This.RecordSource )
>CURSORSETPROP( [Buffering], 3, This.RecordSource )
>ZAP IN ( This.RecordSource )
>CURSORSETPROP( [Buffering], lnBuffering, This.RecordSource )
>SELECT ( This.RecordSource )
>APPEND FROM DBF( [qTmp] )
>GO TOP IN ( This.RecordSOurce )
>This.Refresh()
>
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,"V_COMPANY")
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
