OOTP Developments Forums - View Single Post - CatoBase and Invalid Use of Null: Specific problem, specific help?

SandMan · 03-26-2005, 09:23 AM

If you have MS ACCESS, sort the pitchers by IP for the 1947 season. If you see one with 0 IP and more than 0 ER then add the .333 IP. You stated that you have tons of these in your database? This would be unusual. In 80 seasons of my WBL, I have had this occur only 3 times and each time it blew up in CATO and I did the fix and moved on. Win shares can not be assigned to players with 0 IP, but the program tries to assign WS to any pitcher with runs scored against them. This will blow up each time the 0/+0 error is present. Also check for a player with this criteria who has been traded to or from the DETROIT team.

Hope this helps.

03-26-2005, 09:23 AM	#2
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	If you have MS ACCESS, sort the pitchers by IP for the 1947 season. If you see one with 0 IP and more than 0 ER then add the .333 IP. You stated that you have tons of these in your database? This would be unusual. In 80 seasons of my WBL, I have had this occur only 3 times and each time it blew up in CATO and I did the fix and moved on. Win shares can not be assigned to players with 0 IP, but the program tries to assign WS to any pitcher with runs scored against them. This will blow up each time the 0/+0 error is present. Also check for a player with this criteria who has been traded to or from the DETROIT team. Hope this helps.