Strange 'If'.

[Oldfogey]

Can anyone throw some light on this? I have the following field, 'Years Since' defined. It's stored and has 'Do not calculate if all fields are empty.' flagged.

The YearN Ren fields hold 'R' or are empty.

If(Year0 Ren = "R",0,

If(Year1 Ren = "R", 1,

If(Year2 Ren = "R", 2,

If(Year3 Ren = "R", 3,

If(Year4 Ren = "R", 4, 100))))) - 1

It just does not work. 'Years Since' is always empty no matter what the values in YearN Ren.

If I change it to a Case statement, all the values appear.

If I leave it as a nested If but unflag the 'Do not calculate ... empty', all the values appear.

So I've solved my application problem, but WHY?

The plot thickens! I've checked an old FP3 copy - it's fine. In fact all of the other FP5 copies I have checked are OK. The one causing the trouble is a runtime.

[dbruggmann]

Hello Paul

I tried, but couldn't recreate your problem. Made a little file with the fields Year0 through 4 and your calculation (nested if, stored, do not calculate

[Oldfogey]

Thanks for going to all that trouble. Field formats was one of the first things I checked.

Have now confirmed with my customer that it used to work. (And I mean for years!)

And I think I've solved it - sort of. The solution is developed on a PC for a PC.

I take my Mac laptop to the customer to make minor changes - PC->Zip->Mac->[FIX]->Zip->PC

It is roughly since the last time I did the Mac-PC thing that it no longer works. The field is used in a Find which is not used all that often.

Just hope it hasn't corrupted the file anywhere else to come up and bite me.