Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious Bug in REQUERY()
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00815680
Message ID:
00815976
Views:
15
>This will be very difficult to reproduce as there are so many variables, however, I suspect the
>VFP 8 grid object is likely the cofactor at this point. I will keep you up to date as long as I
>pursue this. Meanwhile, I have instructed my client(s) to revert back to the VFP 6 version as this
>is a serious, serious issue.

Does this code repro the problem for you? It does for me: without the preceding = sign, the first REQUERY works: with it added, as below, it fails. Second one seems to work fine, though.
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)
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform