Stored Procedure no results in Dex - results from SQL command line

I was developing code in Dexterity that involves the use of a stored procedure.  Plenty of examples of this but I was banging my head trying to figure out why the code worked and provided results when I ran it from a SQL Query command, but no results from Dexterity.

I should point out that no error was ever returned!  By Dex or by SQL.

Here was the problem in a nutshell - I was not providing values for all fields in the Dex table I was filling in from the stored procedure.  Once I filled all table fields in the stored procedure it worked in Dex.

Lesson for future reference.