Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any ideas to index/speed this up?
Message
 
À
17/07/2003 15:51:59
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:
00811335
Vues:
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
Cheers,
Jamie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform