1. John Strano
  2. PowerBuilder
  3. Thursday, 21 June 2018
So for the first time in 28 years of PowerBuilder, I have need of the First() method in a DWo expression.
 
You know where I'm going with this right?
 
Maybe I don't expect an answer; maybe I'm just in denial, but...
 
It's an aggregate function?!?!?!
 
OK, so I wish we were at a bar, or in the driveway with the hood of the pickup open with beers in hand to say, "yuh, yuh. There's yer problem."
 
Left ( ColumnA, 6 ) = 'wabbit' AND pos(first(ColumnA for all), 'Murgatroyd') > 0
 
...so this filter expression is null and void because PowerBuilder considers First() an aggregate.
 
Can anyone think or (or has already thought of) a work-around/-through , an equivalent?
 
Want to have the filter kick in, but only when the first row's value for that column is "Murgatroyd".
Accepted Answer
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

You could say it is an aggravate function.

Since you are doing 'for all', you should be able to use column_name[1] .

Comment
Simple when you know how

Odd that the offset is required when the docs say that the first row will be used if the offset is omitted.



Thanks again!



This should allow the filter expression for DWO syntax to include only a context where the processing can be specified to narrow the result set to the desired presentation style.

  1. John Strano
  2. Friday, 22 June 2018
@ David - Isn't that life all over! =Legacy emoji

  1. John Strano
  2. Friday, 22 June 2018
There are no comments made yet.
  1. Thursday, 21 June 2018
  2. PowerBuilder
  3. # Permalink


There are replies in this question but you are not allowed to view the replies from this question.