V6.1 OrderHed.SalesRepList field

Thanks, this will surely be needed. Sorry, I should have figured it was the same as RB (being a Progress product) when you asked and could have suggested it but was too unsure about Progress routines. In RB I usually create a variable called "Tilde" = CHAR(126) in RB just for readability. Not sure if that matters as much in .p land but for anyone still writing RB it is the same seperator.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Aaron Hoyt
Sent: Tuesday, November 08, 2005 10:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V6.1 OrderHed.SalesRepList field


Just to add to community knowledge, and incase I ever wish to search on this
again...
I used the following formula in a .p to pull the first rep out of the field.

rep = ENTRY(1, OrderHed.SalesRepList, chr(126)).

A FOR loop could be used to get each of the 5 entries if needed.
An interesting point, beware the list is ~ separated not , separated as the
Data Dictionary states, hence the need for the chr(126). Turns out "~" is
something special in Progress, so you have to use the chr() to refer to the
separator.

Good luck to others dealing with similar issues.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Aaron Hoyt
Sent: Monday, November 07, 2005 1:51 PM
To: Vantage Group
Subject: [Vantage] V6.1 OrderHed.SalesRepList field


Just a quick question to those playing with progress/.p or similar. Do any
of you know if you can refer to the OrderHed.SalesRepList field entries
using Array methods within progress?
I should have my answer in an hour or two, but I though I would ask the
group to see if anyone could offer a quicker answer and maybe a sample bit
of code.
Thanks,
Aaron Hoyt
Vantage Plastics




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/links
Yahoo! Groups Links









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/links



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
Just a quick question to those playing with progress/.p or similar. Do any
of you know if you can refer to the OrderHed.SalesRepList field entries
using Array methods within progress?
I should have my answer in an hour or two, but I though I would ask the
group to see if anyone could offer a quicker answer and maybe a sample bit
of code.
Thanks,
Aaron Hoyt
Vantage Plastics
Just to add to community knowledge, and incase I ever wish to search on this
again...
I used the following formula in a .p to pull the first rep out of the field.

rep = ENTRY(1, OrderHed.SalesRepList, chr(126)).

A FOR loop could be used to get each of the 5 entries if needed.
An interesting point, beware the list is ~ separated not , separated as the
Data Dictionary states, hence the need for the chr(126). Turns out "~" is
something special in Progress, so you have to use the chr() to refer to the
separator.

Good luck to others dealing with similar issues.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Aaron Hoyt
Sent: Monday, November 07, 2005 1:51 PM
To: Vantage Group
Subject: [Vantage] V6.1 OrderHed.SalesRepList field


Just a quick question to those playing with progress/.p or similar. Do any
of you know if you can refer to the OrderHed.SalesRepList field entries
using Array methods within progress?
I should have my answer in an hour or two, but I though I would ask the
group to see if anyone could offer a quicker answer and maybe a sample bit
of code.
Thanks,
Aaron Hoyt
Vantage Plastics




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/links
Yahoo! Groups Links