Is is possible to make a database field Mandatory in Form if not Mandatory at table level. There is no source code. Domain can be modified as well as table.
But no source code available. Also, it is possible to have blank value at database level but want to make it Mandatory in a particular Form.

Version Baan IV Tools

Thanks in Advance

Jay

hi,

Open Dynamic Form editor -> Go to Field -> Open Field Property-> Checked Mandatory Input

Hi,

You can also do it in Program Script/DAL.

Is is possible to make a database field Mandatory in Form if not Mandatory at table level. There is no source code. Domain can be modified as well as table.
But no source code available. Also, it is possible to have blank value at database level but want to make it Mandatory in a particular Form.

Version Baan IV Tools

Thanks in Advance

Jay

Yes, you can. Just copy the form to your customized VRC and set the "Mandatory Input" option.
(Edit/View Form-->Forms Fields)

As you are in BaanIV so you can't use dal concept here. Also checking mandatory option for the field in form will prompt you a message but you can skip that mandatory option through mouse click into the different fields.

Only option I see (without any code change) is to make changes in table definition, to do so you can copy the table definition in your customized VRC and make the changes.

Note: If you are going to make table def. changes then before that write a correction program for that table's field.

Regards,
Gaurav Kumar

This is Baan IV. Source change not possible. Making the field mandatory is not possible because then it will make it mandatory for all forms.
so, it seems its not possible.
Is there any way by changing the Domain? Like by using legal or illegal characters or using range for the Domain?
Dal, Dynamic Form Editor and source code change is not an option.
Thanks

Hi,

The one way I can think is to create your own session or clone the current session and create a script, add required validations and do an AFS to the existing session or use DAL if its a maintain session and just used for inserting records.