Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on IIF()
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01625898
Message ID:
01625906
Views:
34
>No, you are not silly :). What I didn't say (just for the simplicity) is that I want to set the value "** No Employee ID **" in the column EMPL_NAME where EMPL_ID is blank. So your suggestion with the PADR() in the INDEX expression works though.

Ah, good, I thought it was the lack of coffee after a long weekend where I was rudely awaken by calls from work where I needed to fix problems created by others.. These were probably the last freaking days where I could sleep before my daughter needs rides for the ice rinks at ungodly hours of the weekends...
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform