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:
00410079
Views:
35
>> 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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform