This content has been marked as final. Show 16 replies
I'm on Forms [32 Bit] Version 220.127.116.11.19 (Production)
Oracle9i Enterprise Edition Release 18.104.22.168.0 - Production
With the Partitioning option
JServer Release 22.214.171.124.0 - Production
Oracle Toolkit Version 126.96.36.199.31 (Production)
PL/SQL Version 188.8.131.52.1 (Production)
Oracle Procedure Builder V184.108.40.206.0 Build #1641 - Production
Check Required Property of that Item,
If Required = YES, You need to make it to No, That will solve your problem
OH MY LORD!! THANK YOU!!
That did it! :)
I have the same problem...
The solution to set the "Required" property to "No" seems to work for some of you, but in my case the field already has this property set to No.
Does someone now if there is another solution?
What version are you working on?
Could you give some more info of your form?
I'm working with Forms 6i, but I generate my form by using Designer (also 6i).
I've changed a field from a table used by the form, from number to varchar2. Therefore I changed the data type of this field in the form, but the item from the error message is not the field I've changed...
There are no problems while compiling, only when I run the form...
I didn't change anything else, except the data type of the changed field.
So module designer user still exist ? ;-)
I just switched work and her e they are using it too... for now ;-) I'm in charge to get rid of it
But for you problem
So you did change the datatype as well on your table design as on the module design field. In both you have the requiered/mandatory parameter in the parameter list. These are set correct? both to no?
The item you get the error on is it mandatory , are those settings correct on both sides?
other possibility is to open your generated fmb in forms builder, take a look there and try to run it with the debugger on, ( I always do this because I don't know designer that well) normally you should be able to track where the mandatory is still active.
(I'm more a 9i / 10g forms guy ;-) )
Hope it helps
I just started to learn forms and designer, so I'm also not the big specialist...
That's why there are forums for ;-)
I've checked the changes on the table field in Designer, in Forms builder and also in the table itself and the properties are ok.
The item in error is not mandatory and the settings are ok as well...
I also can't find anything wrong using the debugger :-(
I'm starting to become nervous now :-)
Are you sure that the column in the RDBMS is also not mandatory?
Because you generated your form again but did you make the changes also on the schema where your tables actually are?
I found it!
In my WHEN-NEW-FORM-INSTANCE trigger was a line to put the visible property of that item to false... But when I have a look at the item properties, visible is put to 'Yes'.
I have that line in comment now, and it's working!
That was difficult for us to find out ;-)
I'm glad you found it
Where are you working in Belgium if I may ask?
I work as a consultant for Cronos (Kontich)
That I know well ;-)
give my regards to Pieter Gillis and Karen van Hellemont (iAdvise)
I am experiencing this scenario now. But if you don't mind I would like to know if how does it works for the Required Properties? Just for my knowledge and Understanding.