Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
More Trouble with sql macros
Message
From
02/12/2005 18:24:52
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01074439
Message ID:
01074465
Views:
21
>>>>Rather than Macro substitute your variable, you might prefer to use the EVALUATE function.
>>>
>>>That's the case when macro substitution is more efficient because it's evaluated only once when statement is executed not for every row as EVALUATE().
>>
>>In my test, EVALUATE() executed 6 times for 2 records.
>
>For 2 displayed records or for 2 records total in the table against which BROWSE is run?

2 records in the table, and both met the condition. With 3 records, it executed 8 times, and 4 records 10 times,so there appears to 2 times per record and 2 executions of other overhead.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform