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".