hi friends
my Item descrption Lenth is 40 in one Company . but i have restrict that to 30 in another company How Can i do that ?
regards
satheesh
What do you mean, how can you do that?
Its a change to the property of the Description field in the Item table…
It appears the table definitions in one database are different to the other.
The error is in the company that has the 40 Character description. You will need to write a routine to truncate the length to 30, (maybe put the remaining characters into Description 2) and then find all the bugs in the code where the length was incorrectly changed to 40 and change it back to 30.
hi friends
Actually in tabel 15 G\L Account the name,search name, lenth is 40 but i want restict the lenth to 30 for one comapany there are only 2companies in the DB .So in the name onvalidate Triger i wrote a routine to restrict the lenth is that ok. if you guys have any idiea tell me
Regards
satheesh
Actually, the standard length is 30 and it is not a good idea to increase it unless you really understand that you will need to change a lot of tables to do that.
If you want to restrict the length for one company only, then you can use a routine to check the length everytime user input value into the field.