Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AS Clause
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00409807
Message ID:
00410175
Views:
29
>>> Overall, however, the difference was in the 1000ths of a second, so it ain't something that folks should go running off and doing thinking that it will help their queries.
>
>George,
>
>I'm getting confused, I thought your commetn was that LogicalField = .T. took longer than simply LogicalField. If that was your comment then it is fairly obvious that;
>
>LogicalField=.T. requires that VFP evaluate the Logical Field and then evaluate the comaprison of that field to the literal .T. while the later only requires that VFP evaluate the logical field. That is the former takes two processes while the latter only needs one. Since a logical field IS a logical expression it is not necessary to compare it to a value to get an expression.

JimB,

No confusion, you got it right. I would say that what's obvious to some of us is not necessarily obvious to all (as evidenced by the original query). Chalk it up to gt being his usual AR self when it comes to coding.:-) Unfortunately, however, I think that the handling (comparisons and assignment) of Booleans is something that many folks don't do terribly well. Not to say "badly" or "wrong", mind you. Simply not done as well as it could be. That's just my take, and I may be being a bit too AR here.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform