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:
00815705
Views:
18
I'm not seeing the error: can you provide better repro code? I set up a remote view to SQL's Northwind..Customers database, and ran the following code repeatedly, with no errors.
CLOSE DATABASES all
OPEN DATABASE reqtest
USE reqTest!viewCust NODATA IN 0
USE HOME(1) + "labels" IN 0

SELECT labels

FOR i = 1 TO 200
	lcCust1 = "A"
	lcCust2 = "B"

	lcCustomer = "ALFKI"
	=REQUERY("viewCust")
	lcCust1 = viewCust.customerid

	IF lcCust1 != lcCustomer
		?? "FAIL"
	ENDif

	lcCustomer = "ANATR"
	=REQUERY("viewCust")
	lcCust2 = viewCust.customerID

	IF lcCust2 != lcCustomer
		?? "FAIL"
	ENDIF 

	IF lcCust1 == lcCust2
		?? "Fail"
	ELSE
		?? "Pass"
	ENDIF
ENDfor
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