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