Quick update.
One problem I was having was that I had not renamed the default resultset to 0 to return the first column.
Now I get the error message in the Progress tab
Error: No result rowset is associated with the execution of this query.
So it am still not getting the return value