Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nested IF and multiple queries
Message
From
03/01/2006 09:17:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
03/01/2006 04:05:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01082535
Message ID:
01082575
Views:
8
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform