Changing the number of characters in a field (Vantge 8.03)

That should work just as well, the only catch being that you may have to
use more than one depending on what you're trying to limit.

On Tue, Apr 10, 2012 at 5:08 PM, Dan Godfrey <dgodfrey@...> wrote:

> **
>
>
> Sorry, my bad I forgot to mention that I am in Vantage not E9. BUT . . . I
> like the thought and I am going to research that options, obviously with
> Method directives though.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of John Driggers
> Sent: Tuesday, April 10, 2012 1:48 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Changing the number of characters in a field
> (Vantge 8.03)
>
> You want to limit the characters? You could do that much easier. Just slap
> a data directive on the field and have it raise an exception is the value
> is too large/short/etc.
>
> On Tue, Apr 10, 2012 at 4:19 PM, dgodfrey_amc <dgodfrey_amc@...
> >wrote:
>
> > **
>
> >
> >
> >
> >
> > Hi, I want to bring this post back to the top to see if there are any
> > other options to limit characters to a field. I specifically need to
> > limit a predefined field on the PODetail table. I am hoping that there
> > is something ELSE then the previously explained option.
> >
> > I would think that I can use code through a customization, but is
> > there a more precise way than using code? Or is code it?
> >
> > Dan
> >
> >
> > --- In vantage@yahoogroups.com, "Kevin Simon" <simstrak@...> wrote:
> > >
> > > Rick,
> > >
> > >
> > >
> > > I like this response. It's kind of like: "OK, so if I cut off my
> > > hand, I'll lose a lot of blood and potentially die. Besides that,
> > > are there any other reasons I shouldn't do this? "
> > >
> > >
> > >
> > > Go with the CharacterNN fields instead of the ShortCharNN fields.
> > > Problem solved.
> > >
> > >
> > >
> > > Kevin Simon
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of
> > > Richard
> > > Sent: Friday, February 10, 2012 10:57 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Changing the number of characters in a field
> > (Vantge
> > > 8.03)
> > >
> > >
> > >
> > >
> > >
> > > Jose,
> > > Thanks so much for the response. Besides the caveats you mentioned
> > > are
> > there
> > > other reasons you recommend against this?
> > > Rick
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > Jose Gomez <jose@> wrote:
> > > >
> > > > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO*
> > > > but if
> > you
> > > > feel so inclined.
> > > > I will tell you how to do it in general but will not give you
> > > > specific instructions, if any of these seems un-familiar or
> > > > confuse you, it
> > should
> > > > be another warning sign that you should not do this. :-)
> > > >
> > > > Turn Off Your App Servers and DataBase If you are Progress Get
> > > > into the Data Admin Tool Connect to the DB Find your Table / Field
> > > > Increase the Size Commit your changes Disconnect from DB
> > > >
> > > > If you are in SQL
> > > > I am not 100% sure that making the change on the SQL Databaset
> > > > will propagate to the Progress Schema so you may have to
> > > > investigate.
> > > >
> > > > Turn DB Back On
> > > > Turn App Servers Back On
> > > >
> > > > Rejoice!
> > > >
> > > > Caveats.
> > > > 1. When you upgrade, you may loose this change if they make a
> > > > schema change, so be aware of this 2. The app for the most part
> > > > will be aware of the change you made so
> > you
> > > > should be able to put in more content into this field now, however
> > > > on
> > some
> > > > fields it may still show you a 60 character limit.
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > > *
> > > > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@> wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Good Morning Everyone,
> > > > >
> > > > > Is it possible to change the maximum number of characters in a
> > > > > user defined field? We enter the customer name and part number
> > > > > in a user
> > > defined
> > > > > field on the job entry form. Right now it allows 60 characters
> > > > > but
> > we'd
> > > > > like to expand that. Is there a way to accomplish this?
> > > > >
> > > > > Thanks for your help.
> > > > >
> > > > > Rick
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> --
> *John Driggers*
> *High End Dev, System Design, Profit Drinking*
> *
> **:: 904.404.9233*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
>
> *
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Good Morning Everyone,

Is it possible to change the maximum number of characters in a user defined field? We enter the customer name and part number in a user defined field on the job entry form. Right now it allows 60 characters but we'd like to expand that. Is there a way to accomplish this?

Thanks for your help.

Rick
Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
feel so inclined.
I will tell you how to do it in general but will not give you specific
instructions, if any of these seems un-familiar or confuse you, it should
be another warning sign that you should not do this. :-)

Turn Off Your App Servers and DataBase
If you are Progress
Get into the Data Admin Tool
Connect to the DB
Find your Table / Field
Increase the Size
Commit your changes
Disconnect from DB

If you are in SQL
I am not 100% sure that making the change on the SQL Databaset will
propagate
to the Progress Schema so you may have to investigate.

Turn DB Back On
Turn App Servers Back On

Rejoice!

Caveats.
1. When you upgrade, you may loose this change if they make a schema
change, so be aware of this
2. The app for the most part will be aware of the change you made so you
should be able to put in more content into this field now, however on some
fields it may still show you a 60 character limit.


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:

> **
>
>
> Good Morning Everyone,
>
> Is it possible to change the maximum number of characters in a user
> defined field? We enter the customer name and part number in a user defined
> field on the job entry form. Right now it allows 60 characters but we'd
> like to expand that. Is there a way to accomplish this?
>
> Thanks for your help.
>
> Rick
>
>
>


[Non-text portions of this message have been removed]
If they do a schema change that reduces the number of available fields, I'm
not sure how it would work in progress, but I'm fairly certain on SQL it
would truncate those fields to the new length.

I think the next update to 905 will require a schema change if I recall.

Joshua Giese
Chief Technical Officer
920.437.6400 Ext. 337

*Do not follow where the path may lead. Go instead where there is no path
and leave a trail - Harold R. McAlindon*


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Friday, February 10, 2012 9:02 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Changing the number of characters in a field (Vantge
8.03)

Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
feel so inclined.
I will tell you how to do it in general but will not give you specific
instructions, if any of these seems un-familiar or confuse you, it should
be another warning sign that you should not do this. :-)

Turn Off Your App Servers and DataBase
If you are Progress
Get into the Data Admin Tool
Connect to the DB
Find your Table / Field
Increase the Size
Commit your changes
Disconnect from DB

If you are in SQL
I am not 100% sure that making the change on the SQL Databaset will
propagate
to the Progress Schema so you may have to investigate.

Turn DB Back On
Turn App Servers Back On

Rejoice!

Caveats.
1. When you upgrade, you may loose this change if they make a schema
change, so be aware of this
2. The app for the most part will be aware of the change you made so you
should be able to put in more content into this field now, however on some
fields it may still show you a 60 character limit.


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:

> **
>
>
> Good Morning Everyone,
>
> Is it possible to change the maximum number of characters in a user
> defined field? We enter the customer name and part number in a user
defined
> field on the job entry form. Right now it allows 60 characters but we'd
> like to expand that. Is there a way to accomplish this?
>
> Thanks for your help.
>
> Rick
>
>
>


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Jose,
Thanks so much for the response. Besides the caveats you mentioned are there other reasons you recommend against this?
Rick

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
> feel so inclined.
> I will tell you how to do it in general but will not give you specific
> instructions, if any of these seems un-familiar or confuse you, it should
> be another warning sign that you should not do this. :-)
>
> Turn Off Your App Servers and DataBase
> If you are Progress
> Get into the Data Admin Tool
> Connect to the DB
> Find your Table / Field
> Increase the Size
> Commit your changes
> Disconnect from DB
>
> If you are in SQL
> I am not 100% sure that making the change on the SQL Databaset will
> propagate
> to the Progress Schema so you may have to investigate.
>
> Turn DB Back On
> Turn App Servers Back On
>
> Rejoice!
>
> Caveats.
> 1. When you upgrade, you may loose this change if they make a schema
> change, so be aware of this
> 2. The app for the most part will be aware of the change you made so you
> should be able to put in more content into this field now, however on some
> fields it may still show you a 60 character limit.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:
>
> > **
> >
> >
> > Good Morning Everyone,
> >
> > Is it possible to change the maximum number of characters in a user
> > defined field? We enter the customer name and part number in a user defined
> > field on the job entry form. Right now it allows 60 characters but we'd
> > like to expand that. Is there a way to accomplish this?
> >
> > Thanks for your help.
> >
> > Rick
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
No, i've done it and it works fine as long as you keep that in mind. I
would Certainly avoid doing it wiht any Major Fields. but UDF should be fine

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Feb 10, 2012 at 10:56 AM, Richard <rgraf@...> wrote:

> **
>
>
> Jose,
> Thanks so much for the response. Besides the caveats you mentioned are
> there other reasons you recommend against this?
> Rick
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if
> you
> > feel so inclined.
> > I will tell you how to do it in general but will not give you specific
> > instructions, if any of these seems un-familiar or confuse you, it should
> > be another warning sign that you should not do this. :-)
> >
> > Turn Off Your App Servers and DataBase
> > If you are Progress
> > Get into the Data Admin Tool
> > Connect to the DB
> > Find your Table / Field
> > Increase the Size
> > Commit your changes
> > Disconnect from DB
> >
> > If you are in SQL
> > I am not 100% sure that making the change on the SQL Databaset will
> > propagate
> > to the Progress Schema so you may have to investigate.
> >
> > Turn DB Back On
> > Turn App Servers Back On
> >
> > Rejoice!
> >
> > Caveats.
> > 1. When you upgrade, you may loose this change if they make a schema
> > change, so be aware of this
> > 2. The app for the most part will be aware of the change you made so you
> > should be able to put in more content into this field now, however on
> some
> > fields it may still show you a 60 character limit.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:
> >
> > > **
>
> > >
> > >
> > > Good Morning Everyone,
> > >
> > > Is it possible to change the maximum number of characters in a user
> > > defined field? We enter the customer name and part number in a user
> defined
> > > field on the job entry form. Right now it allows 60 characters but we'd
> > > like to expand that. Is there a way to accomplish this?
> > >
> > > Thanks for your help.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
FWIW, changing it in SQL (only) won’t do a thing. Been there, done that. You still need to change Progress and *then* change SQL.

From: Richard
Sent: Friday, February 10, 2012 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Changing the number of characters in a field (Vantge 8.03)


Jose,
Thanks so much for the response. Besides the caveats you mentioned are there other reasons you recommend against this?
Rick

--- In mailto:vantage%40yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
> feel so inclined.
> I will tell you how to do it in general but will not give you specific
> instructions, if any of these seems un-familiar or confuse you, it should
> be another warning sign that you should not do this. :-)
>
> Turn Off Your App Servers and DataBase
> If you are Progress
> Get into the Data Admin Tool
> Connect to the DB
> Find your Table / Field
> Increase the Size
> Commit your changes
> Disconnect from DB
>
> If you are in SQL
> I am not 100% sure that making the change on the SQL Databaset will
> propagate
> to the Progress Schema so you may have to investigate.
>
> Turn DB Back On
> Turn App Servers Back On
>
> Rejoice!
>
> Caveats.
> 1. When you upgrade, you may loose this change if they make a schema
> change, so be aware of this
> 2. The app for the most part will be aware of the change you made so you
> should be able to put in more content into this field now, however on some
> fields it may still show you a 60 character limit.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:
>
> > **
> >
> >
> > Good Morning Everyone,
> >
> > Is it possible to change the maximum number of characters in a user
> > defined field? We enter the customer name and part number in a user defined
> > field on the job entry form. Right now it allows 60 characters but we'd
> > like to expand that. Is there a way to accomplish this?
> >
> > Thanks for your help.
> >
> > Rick
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2112/4801 - Release Date: 02/10/12


[Non-text portions of this message have been removed]
Assuming that you are using the UD fields in JobHead all you have to do is utilize and of the available UD fields labeled "Character(x)" instead of "UserChar(x)". The Character UD fields are Varchar 2000.


Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/


On Feb 10, 2012, at 6:56 AM, Richard wrote:

> Good Morning Everyone,
>
> Is it possible to change the maximum number of characters in a user defined field? We enter the customer name and part number in a user defined field on the job entry form. Right now it allows 60 characters but we'd like to expand that. Is there a way to accomplish this?
>
> Thanks for your help.
>
> Rick
>
>



[Non-text portions of this message have been removed]
Completely correct because the OE schema handler contains the meta data that communicates the physical schema to the BO's. You could make sweeping changes to SQL server and unless you made the corresponding changes to the OE schema handler the application would never see them.

That being said, I'm totally with Jose. Hacking the schema is a very invasive way to customize the system and should be last resort option if possible.

Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On Feb 10, 2012, at 8:00 AM, Vic Drecchio wrote:

> FWIW, changing it in SQL (only) won�t do a thing. Been there, done that. You still need to change Progress and *then* change SQL.
>
> From: Richard
> Sent: Friday, February 10, 2012 10:56 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Changing the number of characters in a field (Vantge 8.03)
>
> Jose,
> Thanks so much for the response. Besides the caveats you mentioned are there other reasons you recommend against this?
> Rick
>
> --- In mailto:vantage%40yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
> > feel so inclined.
> > I will tell you how to do it in general but will not give you specific
> > instructions, if any of these seems un-familiar or confuse you, it should
> > be another warning sign that you should not do this. :-)
> >
> > Turn Off Your App Servers and DataBase
> > If you are Progress
> > Get into the Data Admin Tool
> > Connect to the DB
> > Find your Table / Field
> > Increase the Size
> > Commit your changes
> > Disconnect from DB
> >
> > If you are in SQL
> > I am not 100% sure that making the change on the SQL Databaset will
> > propagate
> > to the Progress Schema so you may have to investigate.
> >
> > Turn DB Back On
> > Turn App Servers Back On
> >
> > Rejoice!
> >
> > Caveats.
> > 1. When you upgrade, you may loose this change if they make a schema
> > change, so be aware of this
> > 2. The app for the most part will be aware of the change you made so you
> > should be able to put in more content into this field now, however on some
> > fields it may still show you a 60 character limit.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:
> >
> > > **
> > >
> > >
> > > Good Morning Everyone,
> > >
> > > Is it possible to change the maximum number of characters in a user
> > > defined field? We enter the customer name and part number in a user defined
> > > field on the job entry form. Right now it allows 60 characters but we'd
> > > like to expand that. Is there a way to accomplish this?
> > >
> > > Thanks for your help.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2112/4801 - Release Date: 02/10/12
>
> [Non-text portions of this message have been removed]
>
>



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



I like this response. It's kind of like: "OK, so if I cut off my hand,
I'll lose a lot of blood and potentially die. Besides that, are there any
other reasons I shouldn't do this? "



Go with the CharacterNN fields instead of the ShortCharNN fields. Problem
solved.



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Richard
Sent: Friday, February 10, 2012 10:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Changing the number of characters in a field (Vantge
8.03)





Jose,
Thanks so much for the response. Besides the caveats you mentioned are there
other reasons you recommend against this?
Rick

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>
> Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
> feel so inclined.
> I will tell you how to do it in general but will not give you specific
> instructions, if any of these seems un-familiar or confuse you, it should
> be another warning sign that you should not do this. :-)
>
> Turn Off Your App Servers and DataBase
> If you are Progress
> Get into the Data Admin Tool
> Connect to the DB
> Find your Table / Field
> Increase the Size
> Commit your changes
> Disconnect from DB
>
> If you are in SQL
> I am not 100% sure that making the change on the SQL Databaset will
> propagate
> to the Progress Schema so you may have to investigate.
>
> Turn DB Back On
> Turn App Servers Back On
>
> Rejoice!
>
> Caveats.
> 1. When you upgrade, you may loose this change if they make a schema
> change, so be aware of this
> 2. The app for the most part will be aware of the change you made so you
> should be able to put in more content into this field now, however on some
> fields it may still show you a 60 character limit.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@...> wrote:
>
> > **
> >
> >
> > Good Morning Everyone,
> >
> > Is it possible to change the maximum number of characters in a user
> > defined field? We enter the customer name and part number in a user
defined
> > field on the job entry form. Right now it allows 60 characters but we'd
> > like to expand that. Is there a way to accomplish this?
> >
> > Thanks for your help.
> >
> > Rick
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Hi, I want to bring this post back to the top to see if there are any other options to limit characters to a field. I specifically need to limit a predefined field on the PODetail table. I am hoping that there is something ELSE then the previously explained option.

I would think that I can use code through a customization, but is there a more precise way than using code? Or is code it?

Dan

--- In vantage@yahoogroups.com, "Kevin Simon" <simstrak@...> wrote:
>
> Rick,
>
>
>
> I like this response. It's kind of like: "OK, so if I cut off my hand,
> I'll lose a lot of blood and potentially die. Besides that, are there any
> other reasons I shouldn't do this? "
>
>
>
> Go with the CharacterNN fields instead of the ShortCharNN fields. Problem
> solved.
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Richard
> Sent: Friday, February 10, 2012 10:57 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Changing the number of characters in a field (Vantge
> 8.03)
>
>
>
>
>
> Jose,
> Thanks so much for the response. Besides the caveats you mentioned are there
> other reasons you recommend against this?
> Rick
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@> wrote:
> >
> > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if you
> > feel so inclined.
> > I will tell you how to do it in general but will not give you specific
> > instructions, if any of these seems un-familiar or confuse you, it should
> > be another warning sign that you should not do this. :-)
> >
> > Turn Off Your App Servers and DataBase
> > If you are Progress
> > Get into the Data Admin Tool
> > Connect to the DB
> > Find your Table / Field
> > Increase the Size
> > Commit your changes
> > Disconnect from DB
> >
> > If you are in SQL
> > I am not 100% sure that making the change on the SQL Databaset will
> > propagate
> > to the Progress Schema so you may have to investigate.
> >
> > Turn DB Back On
> > Turn App Servers Back On
> >
> > Rejoice!
> >
> > Caveats.
> > 1. When you upgrade, you may loose this change if they make a schema
> > change, so be aware of this
> > 2. The app for the most part will be aware of the change you made so you
> > should be able to put in more content into this field now, however on some
> > fields it may still show you a 60 character limit.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@> wrote:
> >
> > > **
> > >
> > >
> > > Good Morning Everyone,
> > >
> > > Is it possible to change the maximum number of characters in a user
> > > defined field? We enter the customer name and part number in a user
> defined
> > > field on the job entry form. Right now it allows 60 characters but we'd
> > > like to expand that. Is there a way to accomplish this?
> > >
> > > Thanks for your help.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
You want to limit the characters? You could do that much easier. Just slap
a data directive on the field and have it raise an exception is the value
is too large/short/etc.

On Tue, Apr 10, 2012 at 4:19 PM, dgodfrey_amc <dgodfrey_amc@...>wrote:

> **
>
>
>
>
> Hi, I want to bring this post back to the top to see if there are any
> other options to limit characters to a field. I specifically need to limit
> a predefined field on the PODetail table. I am hoping that there is
> something ELSE then the previously explained option.
>
> I would think that I can use code through a customization, but is there a
> more precise way than using code? Or is code it?
>
> Dan
>
>
> --- In vantage@yahoogroups.com, "Kevin Simon" <simstrak@...> wrote:
> >
> > Rick,
> >
> >
> >
> > I like this response. It's kind of like: "OK, so if I cut off my hand,
> > I'll lose a lot of blood and potentially die. Besides that, are there any
> > other reasons I shouldn't do this? "
> >
> >
> >
> > Go with the CharacterNN fields instead of the ShortCharNN fields. Problem
> > solved.
> >
> >
> >
> > Kevin Simon
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Richard
> > Sent: Friday, February 10, 2012 10:57 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Changing the number of characters in a field
> (Vantge
> > 8.03)
> >
> >
> >
> >
> >
> > Jose,
> > Thanks so much for the response. Besides the caveats you mentioned are
> there
> > other reasons you recommend against this?
> > Rick
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> > Gomez <jose@> wrote:
> > >
> > > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO* but if
> you
> > > feel so inclined.
> > > I will tell you how to do it in general but will not give you specific
> > > instructions, if any of these seems un-familiar or confuse you, it
> should
> > > be another warning sign that you should not do this. :-)
> > >
> > > Turn Off Your App Servers and DataBase
> > > If you are Progress
> > > Get into the Data Admin Tool
> > > Connect to the DB
> > > Find your Table / Field
> > > Increase the Size
> > > Commit your changes
> > > Disconnect from DB
> > >
> > > If you are in SQL
> > > I am not 100% sure that making the change on the SQL Databaset will
> > > propagate
> > > to the Progress Schema so you may have to investigate.
> > >
> > > Turn DB Back On
> > > Turn App Servers Back On
> > >
> > > Rejoice!
> > >
> > > Caveats.
> > > 1. When you upgrade, you may loose this change if they make a schema
> > > change, so be aware of this
> > > 2. The app for the most part will be aware of the change you made so
> you
> > > should be able to put in more content into this field now, however on
> some
> > > fields it may still show you a 60 character limit.
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > *
> > > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Good Morning Everyone,
> > > >
> > > > Is it possible to change the maximum number of characters in a user
> > > > defined field? We enter the customer name and part number in a user
> > defined
> > > > field on the job entry form. Right now it allows 60 characters but
> we'd
> > > > like to expand that. Is there a way to accomplish this?
> > > >
> > > > Thanks for your help.
> > > >
> > > > Rick
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Sorry, my bad I forgot to mention that I am in Vantage not E9. BUT . . . I like the thought and I am going to research that options, obviously with Method directives though.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Driggers
Sent: Tuesday, April 10, 2012 1:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Changing the number of characters in a field (Vantge 8.03)

You want to limit the characters? You could do that much easier. Just slap a data directive on the field and have it raise an exception is the value is too large/short/etc.

On Tue, Apr 10, 2012 at 4:19 PM, dgodfrey_amc <dgodfrey_amc@...>wrote:

> **
>
>
>
>
> Hi, I want to bring this post back to the top to see if there are any
> other options to limit characters to a field. I specifically need to
> limit a predefined field on the PODetail table. I am hoping that there
> is something ELSE then the previously explained option.
>
> I would think that I can use code through a customization, but is
> there a more precise way than using code? Or is code it?
>
> Dan
>
>
> --- In vantage@yahoogroups.com, "Kevin Simon" <simstrak@...> wrote:
> >
> > Rick,
> >
> >
> >
> > I like this response. It's kind of like: "OK, so if I cut off my
> > hand, I'll lose a lot of blood and potentially die. Besides that,
> > are there any other reasons I shouldn't do this? "
> >
> >
> >
> > Go with the CharacterNN fields instead of the ShortCharNN fields.
> > Problem solved.
> >
> >
> >
> > Kevin Simon
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Richard
> > Sent: Friday, February 10, 2012 10:57 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Changing the number of characters in a field
> (Vantge
> > 8.03)
> >
> >
> >
> >
> >
> > Jose,
> > Thanks so much for the response. Besides the caveats you mentioned
> > are
> there
> > other reasons you recommend against this?
> > Rick
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > Jose Gomez <jose@> wrote:
> > >
> > > Yes you can do that, however *I HIGHLY DISCOURAGE YOU TO DO SO*
> > > but if
> you
> > > feel so inclined.
> > > I will tell you how to do it in general but will not give you
> > > specific instructions, if any of these seems un-familiar or
> > > confuse you, it
> should
> > > be another warning sign that you should not do this. :-)
> > >
> > > Turn Off Your App Servers and DataBase If you are Progress Get
> > > into the Data Admin Tool Connect to the DB Find your Table / Field
> > > Increase the Size Commit your changes Disconnect from DB
> > >
> > > If you are in SQL
> > > I am not 100% sure that making the change on the SQL Databaset
> > > will propagate to the Progress Schema so you may have to
> > > investigate.
> > >
> > > Turn DB Back On
> > > Turn App Servers Back On
> > >
> > > Rejoice!
> > >
> > > Caveats.
> > > 1. When you upgrade, you may loose this change if they make a
> > > schema change, so be aware of this 2. The app for the most part
> > > will be aware of the change you made so
> you
> > > should be able to put in more content into this field now, however
> > > on
> some
> > > fields it may still show you a 60 character limit.
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > *
> > > *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 Fri, Feb 10, 2012 at 9:56 AM, Richard <rgraf@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Good Morning Everyone,
> > > >
> > > > Is it possible to change the maximum number of characters in a
> > > > user defined field? We enter the customer name and part number
> > > > in a user
> > defined
> > > > field on the job entry form. Right now it allows 60 characters
> > > > but
> we'd
> > > > like to expand that. Is there a way to accomplish this?
> > > >
> > > > Thanks for your help.
> > > >
> > > > Rick
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links