Epcior 9.05.702 - BAQ Help

Yahoo Archive
1
In Progress , in a For Each, you can 'break-by' on a field, then control the results based on the break-by:

/** Loop thru the table for specific parts, break-by   **/

  For Each .partTran Where PartTran.PartType = blah  blah  Break-By PartTran.TranType:

     
      /** get the unique trantypes only once  **/

      IF LAST-OF(PartTran.TranType) then

          display PartTran.TranType.   /**  Or do whatever, **/
    

  End.



On Friday, June 12, 2015 11:10 AM, "'Turgeon, Bill' Bill.Turgeon@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1417899331yiv4332782895ygrp-text">
  
  
  <div>
Is there an equivalent of a SQL select distinct?
I want to see the unique trantype on the tranpart for a specific set of parts.

Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments. 
</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895 -- #ygrps-yiv-1417899331yiv4332782895ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp #ygrps-yiv-1417899331yiv4332782895hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp #ygrps-yiv-1417899331yiv4332782895ads {
margin-bottom:10px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp .ygrps-yiv-1417899331yiv4332782895ad {
padding:0 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp .ygrps-yiv-1417899331yiv4332782895ad p {
margin:0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mkp .ygrps-yiv-1417899331yiv4332782895ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ygrp-lc #ygrps-yiv-1417899331yiv4332782895hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ygrp-lc .ygrps-yiv-1417899331yiv4332782895ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity span {
font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity span span {
color:#ff7900;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895activity span .ygrps-yiv-1417899331yiv4332782895underline {
text-decoration:underline;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895attach div a {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895attach label a {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895bold a {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 dd.ygrps-yiv-1417899331yiv4332782895last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 dd.ygrps-yiv-1417899331yiv4332782895last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 dd.ygrps-yiv-1417899331yiv4332782895last p span.ygrps-yiv-1417899331yiv4332782895yshortcuts {
margin-right:0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895attach-table {
width:400px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895file-title a, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895file-title a:active, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895file-title a:hover, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895photo-title a, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895photo-title a:active, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895photo-title a:hover, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div.ygrps-yiv-1417899331yiv4332782895photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 div#ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg #ygrps-yiv-1417899331yiv4332782895ygrp-msg p a span.ygrps-yiv-1417899331yiv4332782895yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895green {
color:#628c2a;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 o {
font-size:0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895photos div {
float:left;width:72px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895reco-category {
font-size:77%;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895reco-desc {
font-size:77%;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 .ygrps-yiv-1417899331yiv4332782895replbq {
margin:4px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg select, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 input, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg pre, #ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 code {
font:115% monospace;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-mlmsg #ygrps-yiv-1417899331yiv4332782895logo {
padding-bottom:10px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-msg p#ygrps-yiv-1417899331yiv4332782895attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-reco #ygrps-yiv-1417899331yiv4332782895reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-sponsor #ygrps-yiv-1417899331yiv4332782895ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1417899331 #ygrps-yiv-1417899331yiv4332782895 #ygrps-yiv-1417899331yiv4332782895ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1417899331



2

Is there an equivalent of a SQL select distinct?

I want to see the unique trantype on the tranpart for a specific set of parts.


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.