Careful, I'm not sure what this does to any warranties.
Those fields are supposed to be char(1000) but you can actually put a lot
more in them and the only thing that will blow up is Crystal. To correct
that you need to go into the Progress Data Dictionary tool. Click on the
table you want to modify, click on the field and go to the field properties.
You can then change the length of the field so that Crystal will be happy. I
believe you'll have to restart things and re-verify crystal. We just had
someone who was putting in strings of over 3500 characters and it was
storing it but Crystal had a problem getting it out.
I'd think that using a UD table for this type of thing would work better,
having a key of Order/Line and maybe a date-time (down to milliseconds)
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Wednesday, August 19, 2009 5:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: UD Field Length Vantage 8.03.407
Not sure I follow completely....
I thought the Character 01-10 fielda were 1000 bytes which equates to 2000
characters and if you need more than that for a comment, how about
concatenating several fields in your output.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"advantage" <advantage@...> wrote:
Comment Library for a various sort of reasons on a Sales Order Entry Lines
for various customers; so I want a UltraCombo box to go to this UD table and
bring in various commens based on the OrderDtl.ProdCode....and CustID
Those fields are supposed to be char(1000) but you can actually put a lot
more in them and the only thing that will blow up is Crystal. To correct
that you need to go into the Progress Data Dictionary tool. Click on the
table you want to modify, click on the field and go to the field properties.
You can then change the length of the field so that Crystal will be happy. I
believe you'll have to restart things and re-verify crystal. We just had
someone who was putting in strings of over 3500 characters and it was
storing it but Crystal had a problem getting it out.
I'd think that using a UD table for this type of thing would work better,
having a key of Order/Line and maybe a date-time (down to milliseconds)
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Wednesday, August 19, 2009 5:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: UD Field Length Vantage 8.03.407
Not sure I follow completely....
I thought the Character 01-10 fielda were 1000 bytes which equates to 2000
characters and if you need more than that for a comment, how about
concatenating several fields in your output.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"advantage" <advantage@...> wrote:
>have fields longer than 1000 characters so for instance, there will be a
> If I want to create a UserDefined table for comments none of the UD tables
Comment Library for a various sort of reasons on a Sales Order Entry Lines
for various customers; so I want a UltraCombo box to go to this UD table and
bring in various commens based on the OrderDtl.ProdCode....and CustID
> howeve none of the UD fields have fields longer than 1000 characters. Whathave any of you used.
>[Non-text portions of this message have been removed]
> E9 has the ability to extend properties now.
>
>
>
> [Non-text portions of this message have been removed]
>