Order Header Comments

Yahoo Archive
1
So far, BAQ reports are OK. They accurately dump the entire 4500+ memo field to the XML for Crystal. Good to know…… thanks.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Monday, November 26, 2012 1:37 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Order Header Comments





Vic,
This is not as "good" a bug as it seems. Yes, it will save all of those extra characters, but many ODBC reports will crash or simply fail to start because of a length issue with that field. It will then require you to go into the DataDictionary to resize that field to its new maximum size.
-Karl

________________________________
From: Vic Drecchio <vic.drecchio@... <mailto:vic.drecchio%40swepcotube.com> >
To: Vantage Yahoo <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Monday, November 26, 2012 8:04 AM
Subject: [Vantage] Order Header Comments


Ran across a weird thing today. I'm on 8.03.409C and Progress. The Data
Dictionary says that OrderHed.OrderComment field is Type: Character and
Format is X(1000). This tells me that this field has a max of 1000
characters. That doesn't seem to be the case as I just pasted in 4500
characters (according to the Word-Count function in MSWord) into the field,
saved it and came back in to verify it did save all 4500 characters.

I'm not complaining because this is a good "bug" for us, but can anyone
explain this?

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12


[Non-text portions of this message have been removed]
2
Ran across a weird thing today. I'm on 8.03.409C and Progress. The Data
Dictionary says that OrderHed.OrderComment field is Type: Character and
Format is X(1000). This tells me that this field has a max of 1000
characters. That doesn't seem to be the case as I just pasted in 4500
characters (according to the Word-Count function in MSWord) into the field,
saved it and came back in to verify it did save all 4500 characters.



I'm not complaining because this is a good "bug" for us, but can anyone
explain this?






-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12

[Non-text portions of this message have been removed]
3
I've seen this before in SQL, they use VARCHAR(MAX) sometimes even though
the progress SCHEMA has a 1K limit. And Copy / Paste sometimes gets around
that.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, Nov 26, 2012 at 11:04 AM, Vic Drecchio
<vic.drecchio@...>wrote:

> **
>
>
> Ran across a weird thing today. I'm on 8.03.409C and Progress. The Data
> Dictionary says that OrderHed.OrderComment field is Type: Character and
> Format is X(1000). This tells me that this field has a max of 1000
> characters. That doesn't seem to be the case as I just pasted in 4500
> characters (according to the Word-Count function in MSWord) into the field,
> saved it and came back in to verify it did save all 4500 characters.
>
> I'm not complaining because this is a good "bug" for us, but can anyone
> explain this?
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
4
Vic,
This is not as "good" a bug as it seems. Yes, it will save all of those extra characters, but many ODBC reports will crash or simply fail to start because of a length issue with that field. It will then require you to go into the DataDictionary to resize that field to its new maximum size.
-Karl


________________________________
From: Vic Drecchio <vic.drecchio@...>
To: Vantage Yahoo <vantage@yahoogroups.com>
Sent: Monday, November 26, 2012 8:04 AM
Subject: [Vantage] Order Header Comments

Â
Ran across a weird thing today. I'm on 8.03.409C and Progress. The Data
Dictionary says that OrderHed.OrderComment field is Type: Character and
Format is X(1000). This tells me that this field has a max of 1000
characters. That doesn't seem to be the case as I just pasted in 4500
characters (according to the Word-Count function in MSWord) into the field,
saved it and came back in to verify it did save all 4500 characters.

I'm not complaining because this is a good "bug" for us, but can anyone
explain this?

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5420 - Release Date: 11/26/12

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]