Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Carrier up program sentence to a query.
Message
De
19/07/2002 08:50:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Carrier up program sentence to a query.
Divers
Thread ID:
00680389
Message ID:
00680389
Vues:
60
Hello at alls;
I wonder to know, How I have to do to add the above sentece in a query.
I tryed with IIF() but the quantity of IIF is not enoth.
TIA

REPLACE transaccio WITH "Saldos" FOR SUBSTR(proglo,1,8)="BCLSCH30"
REPLACE transaccio WITH "Historico" FOR proglo="BCLSCH33" OR proglo="BCLSCH33A" OR proglo="BCLSCH33C"
REPLACE transaccio WITH "Movimientos" FOR proglo="BCLSCH30AR" OR proglo="BCLSCH31"
REPLACE transaccio WITH "Historico año anterior" FOR proglo="BCLSCH34"
REPLACE transaccio WITH "Tarjetas de credito" FOR proglo="BCLSCH67" OR proglo="BCLSCH67A" OR proglo="BCLSCH89" OR proglo="BCLSCH89A"
REPLACE transaccio WITH "Saldos año anterior" FOR proglo="BCLSCH30SB"
REPLACE transaccio WITH "Inversiones" FOR proglo="BCLSCH40C"
REPLACE transaccio WITH "Diferidos" FOR proglo="BCLSCH32"
REPLACE transaccio WITH "Creditos" FOR proglo="BCLSCH40"
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform