Jump to content

This topic is 8053 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I am getting the following error when trying to do a calculation in a field. Can anybody explain what this means?

FILEMAKER PRO caused an invalid page fault in

module FMFC10.DLL at 017f:006ed28e.

Registers:

EAX=00000070 CS=017f EIP=006ed28e EFLGS=00010202

EBX=5f401901 SS=0187 ESP=009ab9c8 EBP=009aba3c

ECX=00fee9f4 DS=0187 ESI=00fec2f0 FS=67f7

EDX=00fec2f0 ES=0187 EDI=bff555a7 GS=0000

Bytes at CS:EIP:

3b 50 04 74 09 8b 00 85 c0 75 f5 c2 04 00 50 ff

Stack dump:

006fccfe 00fec2f0 bff555a7 00fec2f0 00fec2f0 00fec2f0 009abab0 007051ce 00000001 006fcca2 00fec2f0 5f4019fa 006fcd5b 00000001 5f4056c7 00fec2f0

The calculation is a Case/If Statement:

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "")

Could it be that this is just to busy for FileMaker to handle in one field???

Posted

I started to answer this by suggesting that you replace the "and" in your calculation with the "&" and see what happens. However, as I look at the error message, I realize I have never seen this one before (I'm on a Mac though) so I thought maybe beyond changing the "and" out, I should know more about what the other fields are involved, as to what they contain (you might be mixing numbers, and text or something) and, I should probably know what the end result from this calculation is suppose be.

So, if the changing the calculation doesn't work, let me know.

BTW, I don't think the calculation is "to busy,", for one thing, I do have longer calculations then this that work.

HTH

Lee ooo.gif

Posted

A page fault error is an operating system memory error, not a FileMaker error, per se. Are you running out of RAM on your system. Try this with only FM running.

-bd

This topic is 8053 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.