Hi Michael,
>In a SQL select statement. (original code VFP 5) I came across the code below as part of the WHERE clause
>>(Empty(?ThisForm.Customer) or ?ThisForm.Customer= Ordhead.customerid)
>
>
>As stated previously, empty is not rushmore optimizable, therefore how do I change this to return the same info. I am rewriting the queries in VFP 9 and wish to get the same results.
>
>Mike
If your backend was SQL Server, not VFP, interrogation signal (?) will indicate to SQL that variable after the ? is a external variable (eg.: a public variable in VFP). I think that ? in VFP has no effect (I'm not sure, never try this).
If your form's property
Customer be a number you can to do this:
(ThisForm.Customer = 0 or ThisForm.Customer = Ordhead.customerid)
Good luck!
Erick
Força Sempre!
Strength Always!