User Fields

[Chris Kelleher]

> Hi,
> I need a user field on the cm_mstr table and we've already
> used cm_user1 and cm_user2. Now, I know cm__qad## fields are
> off limits but what about cm__chr## fields? Are these fields
> available or off limits?
>
> MFG/PRO 8.5e
> SUN Solaris 2.5.1
> PROGRESS 8.2b
>
> Thanks,
>
>
> Rick Kane
> Applications Group Manager
> Green Bay Packaging Inc.
> Phone: (920) 433-5184
> Fax: (920) 438-5184
> E-mail: rkane@gbp.com

 

[Chris Kelleher]

they're supposed to be free for your own use, but i would check each field
i'm going to use - whether it's really empty on all records (just a basic
"for each", to be on the safe side).
one other possibility to think about, is the use of the same character field
(like a user1,2 fields) for more than one purpose. if, for example, you use
the two user fields in the same program, you can enter their contents as a
list (comma delimited) to one user field, and then read its content by
calling the correct entry. that way you save a user field for other uses.
it's a very usefull and effective way of using these user fields.

merav
Yaniv-ERP

 

[Chris Kelleher]

Rick,

By definition, we don't use the __chr## fields. However, as has been
suggested, you may wish to doublecheck that by looking for any data there.

You could also consider creating a usr_wkfl record or creating a side
table in a side database (keyed the same as the cm_mstr record, so you can
get to it). The more you do, of course, the more attention you'll have to
pay to housekeeping details (like ensuring that your side record gets
deleted and created along with the main one).

Good luck.

Scott
===============================================================
Scott M. Dulecki /* 1998061901 */ +1 616 975 6322
Product Manager scott_dulecki@qad.com
QAD, Inc. http://www.qad.com
1188 East Paris SE Grand Rapids, MI 49546 USA

Next Michigan Progress Users Group: 17 November 1999

All opinions are my own, and don't necessarily reflect those of
any other living being.
===============================================================