Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Xbase Fox > Re: & Removal i...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 8 Topic 801 of 861
Post > Topic >>

Re: & Removal in Expressions

by Bernhard Sander <fuchs@[EMAIL PROTECTED] > Aug 24, 2007 at 10:12 AM

Hi Gene,

>       select . . .
>       where;
>        wostatus="B" and &dateexpwo and . . .
I think, don't worry about the & in an SQL statement. It is evaluated only
once 
for the whole SQL statement, not for every row examined.

You should only worry, if you have a (fox-) loop and inside the loop you
build 
lots of such SQL statements which return really small result sets. Only
then the 
over all execution time may be affected by the &

Regards
Bernhard Sander
 




 8 Posts in Topic:
& Removal in Expressions
Gene Wirchenko <genew@  2007-08-23 12:48:42 
Re: & Removal in Expressions
"Lew" <lew@[  2007-08-23 16:18:39 
Re: & Removal in Expressions
"Cathy Pountney"  2007-08-23 18:57:46 
Re: & Removal in Expressions
Thomas Ganss <tganss_a  2007-08-25 13:20:29 
Re: & Removal in Expressions
Bernhard Sander <fuchs  2007-08-24 10:12:33 
Re: & Removal in Expressions
Gene Wirchenko <genew@  2007-08-24 09:13:25 
Re: & Removal in Expressions
Cy Welch <cywelch@[EMA  2007-08-26 09:15:16 
Re: & Removal in Expressions
Gene Wirchenko <genew@  2007-08-27 11:59:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 14:15:20 CST 2008.