Jose, thank you very much. Time to let the user test it.
I have a user that would like to display the current rev as the first item In Part Maintenance on the Part tab, Revisions tab, Detail Tab (instead of showing simply by alphanumeric order).
For example: a part has Rev A, B, and C. Rev B is the current approved revision. He would like Rev B to be the first one to appear on the Details tab.
Any suggestions?
Thanks for your help in advance.
Monte
DEFINE TEMP-TABLE ttTarget LIKE ttUD101a.
DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.
Assign
httSource = TEMP-TABLE ttUD101a:HANDLE
httTarget = TEMP-TABLE ttTarget:HANDLE.
FOR EACH ttUD101A BY ttUD101A.ShortChar01:
CREATE ttTarget.
BUFFER-COPY ttUD101A to ttTarget.
END.
httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Wed, Jun 4, 2014 at 3:00 PM, mtisland@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p><span>I have a user that would like to display the current rev as the first item In Part Maintenance on the Part tab, Revisions tab, Detail Tab (instead of showing simply by alphanumeric order). </span></p>
For example: a part has Rev A, B, and C. Rev B is the current approved revision. He would like Rev B to be the first one to appear on the Details tab.
Any suggestions?
Thanks for your help in advance.
Monte
</div> <div style="color:#fff;min-height:0;"></div>
Thanks Jose.
I have this attached to Part.GetByID
Now I get this error:
Compilation error:You cannot define a TEMP-TABLE inside an internal procedure. (3355)
** D:\Epicor\Epicor905\bpmExec\TestBPM\bo\Part\Part.p Could not understand line 133. (196)
Here is my BPM:
/* BPM PartRev Sort */
DEFINE TEMP-TABLE ttTarget LIKE ttPartRev.
DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.
ASSIGN httSource = TEMP-TABLE ttPartRev:HANDLE
httTarget = TEMP-TABLE ttTarget:HANDLE.
FOR EACH ttPartRev BY ttPartRev.Approved DESCENDING BY ttPartRev.RevisionNum:
CREATE ttTarget.
BUFFER-COPY ttPartRev to ttTarget.
END.
httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).
Any more suggestions? Thanks again.
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Thu, Jun 5, 2014 at 9:09 AM, mtisland@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p>Thanks Jose. </p><p><br></p><p>I have this attached to Part.GetByID</p><p><br></p><p>Now I get this error:</p><font size="1"><p>Compilation error:You cannot define a TEMP-TABLE inside an internal procedure. (3355)</p>
** D:\Epicor\Epicor905\bpmExec\TestBPM\bo\Part\Part.p Could not understand line 133. (196)
Here is my BPM:
/* BPM PartRev Sort  */
DEFINE TEMP-TABLE ttTarget LIKE ttPartRev.
DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.ASSIGN httSource = TEMP-TABLE ttPartRev:HANDLE
httTarget = TEMP-TABLE ttTarget:HANDLE.FOR EACH ttPartRev BY ttPartRev.Approved DESCENDING BY ttPartRev.RevisionNum:
 CREATE ttTarget.
 BUFFER-COPY ttPartRev to ttTarget.END.
httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).
Any more suggestions? Thanks again.
</div><div class="ygrps-yiv-39942569"> <div style="color:#fff;min-height:0;"></div>