topic Re: Validation in Application Development and Automation Discussions

Validation

Former Member — Wed, 06 May 2009 10:06:00 GMT

Hi,

I have a ztable.This table is used in the dialog program.Now I want to change the domain of some of the fields, but it is not alowing me to do so.Cant we change the domains of the table once created.

Actually I want to change the domain because I have to ddo the validation of a field which should contain alphanumeric value.For that the domain should be of STRING type, but I have taken it as CHAR type.Now when I am applying the validation , its not working. Please suggest the solution.

Re: Validation

Former Member — Wed, 06 May 2009 10:09:27 GMT

Hi Sunil,

How are you trying to change the domain of the fields?

What error do you get?

Regards,

Ravi

Re: Validation

Former Member — Wed, 06 May 2009 10:09:56 GMT

Hi,

change the domain of the fields in the table save it first but dont try to activate the table now, you will have to adjust it...,

to adjust the table, do the following,

click on utilities menu -> database object -> database utility

and then click on Activate and adjust database button.... let the save data radiobutton be checked...

Regards,

Siddarth

Re: Validation

Former Member — Wed, 06 May 2009 10:29:10 GMT

Hi Sunil ,

Wheher the domains are used in the *key fields* of your table ?

If you you want to change the domain you need to change it and save it , then you should

*adjust* and activate the table .

To adjust the table go to the change mode of the table follow the path specified bellow --

Utilities of the menu bar ---> Database object ---> Database utility --> Activate and Adjust Database.

Regards

Pinaki