ldebondt Posted February 16, 2003 Posted February 16, 2003 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???
Lee Smith Posted February 16, 2003 Posted February 16, 2003 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
LiveOak Posted February 17, 2003 Posted February 17, 2003 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
ldebondt Posted February 17, 2003 Author Posted February 17, 2003 Restructured as a Case statement and works fine.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now