AnsweredAssumed Answered

"Unlocking Hidden Error Messages in the ExecuteSQL Function" does not work for me

Question asked by planteg on May 8, 2015
Latest reply on May 11, 2015 by monkeybreadsoftware

Hi to all of you,

 

I am banging my head to the wall since I have a query that doesn't work. The worst is that Unlocking Hidden Error Messages in the ExecuteSQL Function does not work for me in a real situation. This simple test works (not in the Edit Expression window but in the Data Viewer itself);

ExecuteSQL.jpg

My real world situation is the following:

 

ExecuteSQL_2.jpg

I added a watch on $$ListeDesEmployes in the Data Viewer, if the value returned is "" this is what I Get, but if I return _Res, I get the "?"... Tried with $ListeDesEmployes (using the Script Debuger in order to be sure the contents is not wiped out), same result.

 

Anyone have an idea why this method doesn't work in this situation. Please be aware, I am sometimes hit the Friday Afternoon bug .

 

Thanks

 

Gilles Plante

Outcomes