Michael,
If I'm understanding your goal:
At least on v8, the brain dead version of Progress 4GL supported in BAQ calculated fields doesn't allow one calculated field to be based in anyway upon the value (or a reference) to another calculated field.
If you go to Progress' site, download yourself the (free) pdf version (800-900 or so pages) of the Progress OpenEdge 10(.?), Open Edge Development: Progress 4GL HandBook (Expert Series).
Progress 4GL very much supports array manipulation - just not in the limited version supported by the brain dead BAQ wizard... At least with the handbook, it can really speed up TRYING to squeeze the most out of BAQs (and then knowing when to quit).
What if you used your basic BAQ(s) and pulled them into a dashboard (or an existing suitably related tracker or editing application)?
Then you might be able to use client .Net code to obtain the results you seek.
(Read the BAQ results into a VB defined array or arrays - then do what you desire and dump results into another array defined as an epiTable... Then display that in a custom UltrGrid control?)
Best of luck!
Rob Brown
________________________________
From: michaelogyekye <michaelogyekye@...>
To: vantage@yahoogroups.com
Sent: Friday, June 5, 2009 4:38:41 AM
Subject: [Vantage] Arrays in Vantage
I am comparing two columns of a BAQ and I want to retrive
the index of the last occurrence of a number in column1(array1) and based on this index retrieve the corresponding value in column2 (array).
Is this possible?Does vantage allow array manipulation?
Please help.
[Non-text portions of this message have been removed]
If I'm understanding your goal:
At least on v8, the brain dead version of Progress 4GL supported in BAQ calculated fields doesn't allow one calculated field to be based in anyway upon the value (or a reference) to another calculated field.
If you go to Progress' site, download yourself the (free) pdf version (800-900 or so pages) of the Progress OpenEdge 10(.?), Open Edge Development: Progress 4GL HandBook (Expert Series).
Progress 4GL very much supports array manipulation - just not in the limited version supported by the brain dead BAQ wizard... At least with the handbook, it can really speed up TRYING to squeeze the most out of BAQs (and then knowing when to quit).
What if you used your basic BAQ(s) and pulled them into a dashboard (or an existing suitably related tracker or editing application)?
Then you might be able to use client .Net code to obtain the results you seek.
(Read the BAQ results into a VB defined array or arrays - then do what you desire and dump results into another array defined as an epiTable... Then display that in a custom UltrGrid control?)
Best of luck!
Rob Brown
________________________________
From: michaelogyekye <michaelogyekye@...>
To: vantage@yahoogroups.com
Sent: Friday, June 5, 2009 4:38:41 AM
Subject: [Vantage] Arrays in Vantage
I am comparing two columns of a BAQ and I want to retrive
the index of the last occurrence of a number in column1(array1) and based on this index retrieve the corresponding value in column2 (array).
Is this possible?Does vantage allow array manipulation?
Please help.
[Non-text portions of this message have been removed]