1. David Peace (Powersoft)
  2. PowerBuilder
  3. Friday, 11 September 2020 13:12 PM UTC

Hi Guys

I have a problem with PB102R3 Build 1915

The DW filter is not being applied until after the retrieveend event, I'm pretty certain that in previous releases it was applied before the retrieveend. I can code round this, but can someone confirm that what I am saying is true?

Thanks

David

David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Friday, 11 September 2020 13:33 PM UTC
  2. PowerBuilder
  3. # 1

I have just read the Help in detail and it says "The number of rows retrieved in the rowcount argument is an unfiltered value.", The implication i sthat the rows are not filtered.

So PB has always been this way and I had not realised. Code that has been the same for over a decade and worked, worked by pure chance! Code is not fixed :)

Sometimes you can teach an old dog new tricks :)

 

Comment
  1. Chris Pollach @Appeon
  2. Friday, 11 September 2020 14:03 PM UTC
Hi David;

FWIW: In my frameworks, I have always handled the processing of the DWO's result set in a POST oe_RetrieveEnd event. That way, you know that all *static* Filter and Sort commands have now been completed.

HTH

Regards ... Chris
  1. Helpful
  1. David Peace (Powersoft)
  2. Friday, 11 September 2020 15:36 PM UTC
Thanks Chris

Yes, that's what I changed for this too. Not my code I just support it now.... it has worked (allegedly) for over 10 years and has only now gone wrong! I think it was always wrong with the right data set ;-)



I did think I was loosing my mind today :)



Take care

David
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 11 September 2020 19:19 PM UTC
Hi David;

Awesome!

Yes, I have been developing using my frameworks since 1992 and have encountered many changes to the way / order that events and internal features fire. That is why you'll see me use a lot of posted oe_xxxx() events so that the frameworks and Apps built from them can reply on when its safe (ie: all background processing has been completed) to process the PB App's code. That also includes PowerServer.

Over time I have had to alter the timing of these oe_xxx events or add delays etc to make sure from one PB release to another (from PowerSoft, Sybase, SAP and yes, even Appeon) to ensure proper processing. That even included changes caused by O/S's like XP=>W7=>W8=>W10=>?W?. Of course, that is the whole purpose of the frameworks ... to shield the PB Apps from these type of changes, allow best practice implementation and extend their feature set & functionality. ;-)

Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.