Method to populate a user field in existing records (V8.03 Progr

Yahoo Archive
1
FOR EACH UD01
DELETE UD01.
END.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Sat, May 30, 2015 at 4:18 PM, ckrusen1@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thanks.  Worked perfect, after a few tweaks.</p><div><br></div><div>The UD01.Key1 and OrderHed.Num weren&#39;t compatible, so I filed the UD01.Number01 with the order number, and had to cast that to an integer to do the comparison.</div><div><br></div><div>Now how do I empty the UD table?</div><div><br></div><div>I assume it would be something like:</div><div><br></div><div><span style="color:rgb(63,63,63);">FOR EACH UD01: </span><br style="color:rgb(63,63,63);"><span style="color:rgb(63,63,63);">// some magic function call to delete the row //</span><br style="color:rgb(63,63,63);"><span style="color:rgb(63,63,63);">END. </span><br></div><div><span style="color:rgb(63,63,63);"><br></span></div><div><span style="color:rgb(63,63,63);">With that &#39;magic function call&#39; being what I don&#39;t know.</span></div><div><span style="color:rgb(63,63,63);"><br></span></div><div><span style="color:rgb(63,63,63);">Calvin</span></div><div><br></div><p></p>

</div>
 


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

2

I need to populate the user field ShortChar08 (SC08) in existing records in the OrderHed table.


The value isn't constant or easily derived from data in the OrderHed or related tables.  I have a spreadsheet with two columns: OrderNumber, and SC08.  The values in SC08 were manually entered.


Whats the easiest way to update SC08 in the OrderHed table, given I have a 'table' containing the value for each OrderNum?

 

3

Easiest is DMT, otherwise an updateable dashboard would be the next best.

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-862-9862

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 7:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Method to populate a user field in existing records (V8.03 Progress DB)

 

 

I need to populate the user field ShortChar08 (SC08) in existing records in the OrderHed table.



The value isn't constant or easily derived from data in the OrderHed or related tables.  I have a spreadsheet with two columns: OrderNumber, and SC08.  The values in SC08 were manually entered.



Whats the easiest way to update SC08 in the OrderHed table, given I have a 'table' containing the value for each OrderNum?

 

4
Since those tools aren’t available for your version and you are progress, way back in the day of early 8 sometimes we would do a paste insert into the list tab on a UD table and then write some ABL in a BPM on a simple trigger for that UD table and write directly to whatever tables we were trying to update.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Method to populate a user field in existing records (V8.03 Progress DB)


Easiest is DMT, otherwise an updateable dashboard would be the next best.

Charlie Smith
CTCharlie@...
Cell: 860-919-1708
Office: 817-862-9862

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 7:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Method to populate a user field in existing records (V8.03 Progress DB)



I need to populate the user field ShortChar08 (SC08) in existing records in the OrderHed table.




The value isn't constant or easily derived from data in the OrderHed or related tables. I have a spreadsheet with two columns: OrderNumber, and SC08. The values in SC08 were manually entered.




Whats the easiest way to update SC08 in the OrderHed table, given I have a 'table' containing the value for each OrderNum?





[Non-text portions of this message have been removed]
5
Thanks.  That was the direction I was leaning.  But without the ABL coding.

I was hoping to do something simple like make  a customization with an UltraGrid with just the columns OrderHed.OrderNum and OrderHead.ShortChar08, and then do a 'Paste Update'

But I can't figure out how to get all the OrderHed records at once.  I added the grid to custom tab in the Order Entry screen, but that only shows one record at a time.

Is there a way to have an updatable grid, that displays select columns of all the records in a table?

Key part there is it must be updateable.  And yes I would limit updates to the UD field. (wouldn't want to "break" anything)


6
In 8… without a lot of coding… probably not happening from what I know. All those toolsets exist in 9 or later..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 11:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Method to populate a user field in existing records (V8.03 Progress DB)



Thanks. That was the direction I was leaning. But without the ABL coding.

I was hoping to do something simple like make a customization with an UltraGrid with just the columns OrderHed.OrderNum and OrderHead.ShortChar08, and then do a 'Paste Update'

But I can't figure out how to get all the OrderHed records at once. I added the grid to custom tab in the Order Entry screen, but that only shows one record at a time.

Is there a way to have an updatable grid, that displays select columns of all the records in a table?

Key part there is it must be updateable. And yes I would limit updates to the UD field. (wouldn't want to "break" anything)





[Non-text portions of this message have been removed]
7
You can't do updatable anythiung in 8x but go the way of ABL its not that hard, Paste Insert your stuff into UD01 Grid. Then put a BPM on ABCCOde.GetNewABC (pre proc... I picked that one cause its an easy bo... but it doesn't matter)
Do the following

FOR EACH UD01, EACH OrderHed WHERE OrderHed.Company = UD01.Company AND OrderHed.OrderNum = UD01.FieldHoldingOrderNum:
​​run lib\UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, 'ShortChar08', UD01.FieldHoldingTheValye).

END.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, May 29, 2015 at 12:13 PM, Rob Bucek rbucek@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>In 8… without a lot of coding… probably not happening from what I know.  All those toolsets exist in 9 or later..



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 11:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Method to populate a user field in existing records (V8.03 Progress DB)



Thanks. That was the direction I was leaning. But without the ABL coding.

I was hoping to do something simple like make a customization with an UltraGrid with just the columns OrderHed.OrderNum and OrderHead.ShortChar08, and then do a 'Paste Update'

But I can't figure out how to get all the OrderHed records at once. I added the grid to custom tab in the Order Entry screen, but that only shows one record at a time.

Is there a way to have an updatable grid, that displays select columns of all the records in a table?

Key part there is it must be updateable. And yes I would limit updates to the UD field. (wouldn't want to "break" anything)




[Non-text portions of this message have been removed]

</div>
 


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

8
See, told ya ☺

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 11:21 AM
To: Vantage
Subject: Re: [Vantage] Re: Method to populate a user field in existing records (V8.03 Progress DB)


You can't do updatable anythiung in 8x but go the way of ABL its not that hard, Paste Insert your stuff into UD01 Grid. Then put a BPM on ABCCOde.GetNewABC (pre proc... I picked that one cause its an easy bo... but it doesn't matter)
Do the following

FOR EACH UD01, EACH OrderHed WHERE OrderHed.Company = UD01.Company AND OrderHed.OrderNum = UD01.FieldHoldingOrderNum:
​​run lib\UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, 'ShortChar08', UD01.FieldHoldingTheValye).

END.


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, May 29, 2015 at 12:13 PM, Rob Bucek rbucek@...<mailto:rbucek@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


In 8… without a lot of coding… probably not happening from what I know. All those toolsets exist in 9 or later..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311<tel:%28715%29%20284-5376%20ext%20311>
Mobile: (715)896-3119<tel:%28715%29896-3119>
FAX: (715)284-4084<tel:%28715%29284-4084>
[cid:1.234354861@...<mailto:cid%3A1.234354861@...>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]
Sent: Friday, May 29, 2015 11:10 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] Re: Method to populate a user field in existing records (V8.03 Progress DB)



Thanks. That was the direction I was leaning. But without the ABL coding.

I was hoping to do something simple like make a customization with an UltraGrid with just the columns OrderHed.OrderNum and OrderHead.ShortChar08, and then do a 'Paste Update'

But I can't figure out how to get all the OrderHed records at once. I added the grid to custom tab in the Order Entry screen, but that only shows one record at a time.

Is there a way to have an updatable grid, that displays select columns of all the records in a table?

Key part there is it must be updateable. And yes I would limit updates to the UD field. (wouldn't want to "break" anything)




[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
9
Thanks.  Worked perfect, after a few tweaks.

The UD01.Key1 and OrderHed.Num weren't compatible, so I filed the UD01.Number01 with the order number, and had to cast that to an integer to do the comparison.

Now how do I empty the UD table?

I assume it would be something like:

FOR EACH UD01: 
// some magic function call to delete the row //
END. 

With that 'magic function call' being what I don't know.

Calvin