step by step:

  1. after understanding the example you create a temporary table
    • by own hands
  2. then you compose a SQL query to feed your Resultset
    • by own hands
  3. with your query you create a %SQL.Statement
    • by own hands
  4.  running %Execute generates %SQLStatementResult

BINGO
 You may publish your code on OpenExchange as an example.

Josephus Flav · Nov 14, 2025 go to post

not ARCHIVE, rather name it MUSEUM.

if you find bones of a dinosaur nobody would expect to raise a full beast

It will be deposited in a museum as an historic artefact instead
 

Josephus Flav · Sep 28, 2025 go to post

What is this hidden Quality Report you are talking about ?
At least something invisible to standard users of the Community and OpenExchange.
You must be somehow privileged.  Publish your secrets !    

Josephus Flav · Jun 2, 2024 go to post

How many CSP pages have you traced in operation before?

You might need to study documentation or take some related training.
 

Josephus Flav · Apr 24, 2024 go to post

What you intend to do is completely against the concept of Caché and IRIS
And against most concepts that made the core products strong.

It's best compared to take out all vocals from written language.

The logic lies in the design of the system
So you probably should change the logic that requires such sick actions.
 

Josephus Flav · Feb 7, 2023 go to post

i see some items that date back for several month/year ??
But I see them in OEX Tool Contest as well.  Not very fresh!.

Josephus Flav · Mar 5, 2021 go to post

A nice side effect:
I finally have separated Code from Data.
I know it was possible in Caché all the time. But who really did it without any pain?