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:
00815724
Views:
17
Garrett,

I find it interesting that using the "=" seems most corrosive and that any of the variations actually make a difference (not doubting the submission, just see it as odd).
In the back of my mind I recollect one bug report that was bypassed by inserting the "=" in the method call and yet another that was bypassed by coding the parens. at the end of a method call, so these things obviously *can* have some impact on execution.

Do you have any considerations on that aspect of the report?

cheers

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform