Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Carrier up program sentence to a query.
Message
From
19/07/2002 08:50:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Carrier up program sentence to a query.
Miscellaneous
Thread ID:
00680389
Message ID:
00680389
Views:
61
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"
Next
Reply
Map
View

Click here to load this message in the networking platform