Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nested IF and multiple queries
Message
De
03/01/2006 09:17:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
03/01/2006 04:05:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01082535
Message ID:
01082575
Vues:
7
>Hi all
>I am new to vfp and facing some problems like following;
>I want to use nested IF in a report; and
>I want to execute multiple queries in a single report.
>
>Can anybody help me?
>Anybody in Lahore if can spare some time to teach me vfp? I can pay for it
>
>regards

In the report, instead of the if command, you can use the iif() function. For example, let's say you have a logical field "Enabled", your report expression might be:
iif(Enabled, "Enabled", "Disabled")
iif() can be nested, too:
iif(x = 1, "one", iif(x = 2, "two", "more than two"))
But quite often, it is more convenient to prepare all data in the cursor, before you run the report - as Çetin explained.

With respect to the "multiple queries", I am not sure what you mean; perhaps you can give some additional explanations.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform