Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any ideas to index/speed this up?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810823
Message ID:
00811339
Views:
8
>>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
>
Not true!

CREATE CURSOR test1 (f1 C(10))
CREATE CURSOR test2 (f1 C(10))
INSERT INTO test1 VALUES ("Initial")
INSERT INTO test2 VALUES ("Initial")
?test1.f1
?test2.f1
SELECT test2
REPLACE test1.f1 WITH "not current"
?test1.f1
?test2.f1
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform