Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert 'fieldB' in a grid if 'fieldA' is empty
Message
From
13/05/2014 04:14:42
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
12/05/2014 23:33:09
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01599900
Message ID:
01599905
Views:
64
>Hi. VFP7 user. I am working with a grid. I want to say
>
IIF ( EMPTY(fieldA), fieldB, fieldA )
>I tried placing the code in the control source. Got "must be a variable ref" error.
>My q: where can I put this code where it will act on every row of the grid?
>
>thanks, Randy

Addition to Al Domans message: I prefer to add the alias to the fields.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform