Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any ideas to index/speed this up?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00810823
Message ID:
00811339
Vues:
9
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform