13 Replies Latest reply on May 11, 2015 4:13 AM by monkeybreadsoftware

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

    planteg

      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