Validation

[Former Member]

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.

[Former Member]

Hi Sunil,

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

What error do you get?

Regards,

Ravi

[Former Member]

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

[Former Member]

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