CLOSE DATABASES all clear DELETE DATABASE testRequery DELETETABLES CREATE DATABASE testRequery con=SQLstringCONNECT("driver=sql server;server=(local)") IF con<1 ? "Faildd to connect!!!" RETURN ENDIF CREATE CONNECTION testcon CONNSTRING (SQLGETPROP(con,"ConnectString")) SQLDISCONNECT(con) con=SQLCONNECT("testcon") SQLEXEC(con,"DROP TABLE testuse") SQLEXEC(con,"create table testuse (f1 varchar(10))") SQLEXEC(con,"insert into testuse values ('AAAA')") SQLEXEC(con,"insert into testuse values ('BBBB')") CREATE SQL VIEW testuse REMOTE CONNECTION testcon share as select * from testuse WHERE f1=?cParam cParam="AAAA" USE testuse GO top ?f1,"Should be 'AAAA'" cParam="BBBB" CURSORSETPROP("AllowSimultaneousFetch",.T.) =REQUERY() GO top ?f1,"Should be 'BBBB' <======================= !!!" =REQUERY() GO top ?f1,"Should be 'BBBB'" CLOSE DATABASES all SQLDISCONNECT(0)