Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What does this text do?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
What does this text do?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01348085
Message ID:
01348085
Views:
44
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
Next
Reply
Map
View

Click here to load this message in the networking platform