Ironical I know but.....
I have never used or never needed to use the EXEC_SPF capability in Aware...... Until this last weekend...
Spent hours trying to get a complex Query to work without joy.... but then a light came on...
Maybe I could do this with a Stored Procedure returning a Value....
Dig our Bruce Lomasky's Conference Presentation and Video.
Throw the question to Chat GPT for the SP code.
Bamm!! 30 minutes later... Problem Solved....
Awesome!