Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore - Optimization level
Message
 
 
To
12/05/2005 12:00:22
Emerson Reed
Folhamatic Tecnologia Em Sistemas
Americana - São Paulo, Brazil
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01013468
Message ID:
01013472
Views:
10
>The otimization level is only showed to SQL commands?
>See the following code:
>
>Local lcUf, lcResultadoDoTeste
>lcUf = "ES"
>Select Clientes
>Sys(3054,1,"lcResultadoDoTeste")
>Locate For Uf = lcUf
>Messagebox(lcResultadoDoTeste)
>
>Messagebox always shows an empty value...

Yes, the optimization level is only shown for SELECT command. You can plug your condition into a simple query to see how it will be optimized.
SELECT * FROM Clientes ;
  WHERE Uf = lcUf
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform