Sort tt Table data on BPM?

Thanks man.

 

 

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

 

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, April 15, 2014 3:51 PM
To: Vantage
Subject: Re: [Vantage] Re: Sort tt Table data on BPM?

 

 

No. MAUAHAHHA! Ok just kidding here it is

 

This will sort the ttTable by ShortChar01 (this is on Post Proc get byid)

 

 

/* This line needs to be in the declaration */ 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

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Apr 15, 2014 at 5:43 PM, Marco Vissuet <mvissuet@...> wrote:

 

Are you going to tell us your secret?

 

 

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

 

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, April 15, 2014 1:14 PM
To: Vantage
Subject: [Vantage] Re: Sort tt Table data on BPM?

 

 

I did it, so disregard the question.​



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Apr 15, 2014 at 3:43 PM, Jose Gomez <jose@...> wrote:

Hi Guys,

I have the need to return the data from a metho d call on a specific order.

I am trying to write  a BPM on post proc that will sort the contents of a TTTable, I know how to sort on a foreach but that doesn't re-arrange the actual data on the ttTable. I was wondering if anyone knew of a way to do this

 

Thanks

 

 


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9681 (20140415) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9681 (20140415) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

Hi Guys,
I have the need to return the data from a metho d call on a specific order.
I am trying to write  a BPM on post proc that will sort the contents of a TTTable, I know how to sort on a foreach but that doesn't re-arrange the actual data on the ttTable. I was wondering if anyone knew of a way to do this

Thanks




Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?
I did it, so disregard the question.​


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile

E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Tue, Apr 15, 2014 at 3:43 PM, Jose Gomez <jose@...> wrote:
Hi Guys,
I have the need to return the data from a metho d call on a specific order.
I am trying to write  a BPM on post proc that will sort the contents of a TTTable, I know how to sort on a foreach but that doesn't re-arrange the actual data on the ttTable. I was wondering if anyone knew of a way to do this

Thanks




Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?

Are you going to tell us your secret?

 

 

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

 

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, April 15, 2014 1:14 PM
To: Vantage
Subject: [Vantage] Re: Sort tt Table data on BPM?

 

 

I did it, so disregard the question.​



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Apr 15, 2014 at 3:43 PM, Jose Gomez <jose@...> wrote:

Hi Guys,

I have the need to return the data from a metho d call on a specific order.

I am trying to write  a BPM on post proc that will sort the contents of a TTTable, I know how to sort on a foreach but that doesn't re-arrange the actual data on the ttTable. I was wondering if anyone knew of a way to do this

 

Thanks

 

 


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9681 (20140415) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

No. MAUAHAHHA! Ok just kidding here it is


This will sort the ttTable by ShortChar01 (this is on Post Proc get byid)



/* This line needs to be in the declaration */
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

Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Tue, Apr 15, 2014 at 5:43 PM, Marco Vissuet <mvissuet@...> wrote:

Â
<div>
  
  
  <p>

Are you going to tell us your secret?

Â

Â

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

Â

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, April 15, 2014 1:14 PM
To: Vantage
Subject: [Vantage] Re: Sort tt Table data on BPM?

Â

Â

I did it, so disregard the question.​



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com
 Â
   Â


Quis custodiet ipsos custodes?

Â

On Tue, Apr 15, 2014 at 3:43 PM, Jose Gomez <jose@...> wrote:

Hi Guys,

I have the need to return the data from a metho d call on a specific order.

I am trying to write  a BPM on post proc that will sort the contents of a TTTable, I know how to sort on a foreach but that doesn't re-arrange the actual data on the ttTable. I was wondering if anyone knew of a way to do this

Â

Thanks

Â

Â


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com
 Â
   Â


Quis custodiet ipsos custodes?

Â

Â

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9681 (20140415) __________

Â

The message was checked by ESET NOD32 Antivirus.

Â

http://www.eset.com

</div>
 


<div style="color:#fff;min-height:0;"></div>