Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any ideas to index/speed this up?
Message
 
To
17/07/2003 15:51:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810823
Message ID:
00811335
Views:
7
>REPLACE cdr.rate WITH rate ;
>, cdr.charge with IIF(cdr.duration>0,rate*cdr.billdur,0) :
>FOR empty(cdr.rate)
>

This doesn't help you with your question in any way but one thing that you may not realise (it took me a while to realise) is that REPLACE pays no attention to the alias of the field you are replacing.

ie. REPLACE cdr.rate - the "cdr" is ignored by VFP. What replace actually does is replaces the fields in the CURRENT alias unless you have an IN clause. SO what is much better is :
REPLACE myfield WITH myval IN myalias
Cheers,
Jamie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform