Oracle Forms

Hi everyone,,

I have a form that contains 12 fields representing 12 months of the year. These fields will contain values like : $ 100000,45; 0,00 or 0,01.

All fields are Numeric and have a Format mask ''$999G999G999G999G999D99''. When I lunch the form I got $,00 as default value.
If I enter a number for example : 12 in field and save, everything works fine. Then, I can modify this value at any time that I want.
But if I enter 0 in a field and Save the value, everything works fine, but when I want to update this value (0) I received and error FRM-40509 - Record update id impossible.

I change the format mask of my fields, that didn't resolve my problem.

Any idea?

I have to correct that problem today and test it and go on production ASAP.

Thanks for any help,


Charly



my forms version

Forms [32 bits] Version 10.1.2.0.2 (Production)
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 10.1.2.0.2 - Production
Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.4.0 Production