What's the equivalent of Access's Switch(,,) statement

[robmoors]

Can someone please tell me what's the equivalent of Access's Switch(,,) statement in Foxpro. I know the IIF statement but not the Switch.

 

[DEDMOD]

I'm not sure there is an exact replacement. I'd think, however, that you could do the same thing with a do case ... endcase statement, though the code might be a bit longer. Thus to use the example my Access has using the switch function

DO CASE
       CASE CityName = "London"
                MatchUp = "English"
       CASE CityName = "Paris"
                MatchUp = "French"
       CASE CityName = "Rome"
                MatchUp = "Italian"
       OTHERWISE
                MatchUp = "No Match"
ENDCASE

The case structure has a lot more capabilities, but the visible overhead is a bit larger.

Dave Dardinger

 

[jonscott8]

OTTOMH, I cant think of one in VFP6. To achieve the same functionality, you can use nested IIFs, a case statement, and there's also the Inlist function. Jon Hawkins

 

[robmoors]

Thanx for the help

 

[marsh]

I don't know Access, but if switch is replacing one string with another, look in your help files for STRTRAN().