flysurfing
22nd October 2008, 07:18
Hello,
We need to increase from 30 to 80 characters the Description Field located in the ITEM - GENERAL Table.
Is it possible to do that ?
Thanks a lot,
Fly
zardoz
22nd October 2008, 10:03
You have 2 ways to do so:
1) by changing the definition of tcdsca, increasing to 80 chars the description
2) by defining a new domain, say tcdsca.c and linking to the item description.
If you choose option 1 the disavantage is that all the fields that have tcdsca will be increasing to 80 chars.
flysurfing
22nd October 2008, 10:09
You have 2 ways to do so:
1) by changing the definition of tcdsca, increasing to 80 chars the description
2) by defining a new domain, say tcdsca.c and linking to the item description.
If you choose option 1 the disavantage is that all the fields that have tcdsca will be increasing to 80 chars.
Thanks for your answer, but can you tell me,
How to change the definition of TCDSCA ?
Where should i go (i am not a programmer but have some skills)
Thanks,
Fly
shanmukhi
22nd October 2008, 13:53
Hi,
It is better to create a new domain and keep ur lengh upto 80.
but plz eloborate me ur requirement.
flysurfing
23rd October 2008, 03:56
Dear Shanmukhi,
We just need to increase the size of the Description field as described above to 80 characters.
Shall be perfect if we can do so with a simple modification.
What do you think of it ?
Thanks
Fly
zardoz
23rd October 2008, 10:22
The changes are simple, but requires some use of tools. Seems from your question you never used yet, so I can resume all the steps:
1) Have you already a custom PVRC?
2) If yes, have an user with customization authorizations and is positioned on this VRC?
3) If yes to both, you have to go to maintain domains, create a new domain, says tcdsca.c with 80 chars.
4) Then go in maintain tables, copy tcibd001 to the current PVRC and change the domain of tcdsca with tcdsca.c
6) Run convert to RTDD
7) Compile every session in which there is dsca
8) Go in every report on which there is dsca and do the necessary changes to the layouts, then compile them
flysurfing
23rd October 2008, 10:33
Hello Zardoz...
No we don't use PVRC because we never did any dev. on it...
The company working with us don't want to do any modification on the software, saying it is impossible!
What do you think of that ?
Do you think i can increase the size of the field by myself?
Cheers,
Fly
shanmukhi
23rd October 2008, 10:45
Hi Mr Fly,
Mr. Zardoz has given a brief and good process for your tic..
I think this will help u more...
try it..
zardoz
23rd October 2008, 15:40
The process is that I have told you, and if you can or can't do that due to company restrictions nobody can tell you...
mark_h
23rd October 2008, 16:06
Hello Zardoz...
No we don't use PVRC because we never did any dev. on it...
The company working with us don't want to do any modification on the software, saying it is impossible!
What do you think of that ?
Do you think i can increase the size of the field by myself?
Cheers,
Fly
As Zardoz says - nope.
Of course you can always pay infor to make the changes for you. And for a fee I am sure they will support it going forward.