I don't mean to be a pain (too late for that) but I was wondering if there were any changes in the status of CAN-FIND and BREAK BY in queries, especially CAN-FIND and especially in cases where the query is dynamic, for coming releases of course.
I know we've discussed this topic here before and there were some very promising responses made by Salvador Vinals but it's a problem that I keep running into quite often and always finding new and terrible ways that some people come up with to get around them.
Many thanks.
... just talking to myself
IMVHO and I'm sorry to say, whatever we've got is just not enough or just not good enough.
OK it's Progress and because queries are record oriented etc. and the query language is a very integral part of the language it's expected that for some queries there's code involved, for example, grouping, and that's not a problem it's great but the lack of these fundamental and basic features is a problem and it's been a problem for a very long time. It's a problem that you have to write a whole program with all kinds of work arounds everytime there's a query that's abit more complicated.
I'm sorry but IMVHO the work arounds aren't good enough and are certainly not a permanent solution. They're not dynamic, they're limited, they're not performant, they're not simple, they're not obvious or even well known and there are alot of problematic implementations some developers out there are using, heck, there not even documented except for a few mentions in the KB (that IMVHO could be rewritten a little bit clearer). These are much needed fundamental, basic capabilities they're not something esoteric in anyway.
Personally, I'd be very happy if there could be some sort of compromise done to meet us half way and get these sorting and functionality similar to EXISTS into ABL queries. Maybe setting external buffers, for example, SET-EXTERNAL-BUFFERS( ) would work ??
We are five years down the line now and obviously still running into this limitation frequently.
But one thing has changed: PSC has moved focus back to OpenEdge!
Does this mean that this issue will be addressed in the near future???
A new message was posted in the thread "CAN-FIND and BREAK BY in
queries.":
BREAK-BY is available in queries, since 10.1C I believe. CAN-FIND is still not in.
-- peter
pjudge wrote:
A new message was posted in the thread "CAN-FIND and BREAK BY in
queries.":
BREAK-BY is available in queries, since 10.1C I believe. CAN-FIND is still not in.
-- peter
Yes you are right, it's the CAN-FIND I am asking for.
Can you tell us if that is on anyone's radar at the moment?
it's on a lot of peoples radar.
just not the right people
According to Mary: