1 2 Previous Next 22 Replies Latest reply on Jun 13, 2017 10:11 AM by beverly

    Need ExecuteSQL Help

    xxx202xxx

      Lack of ExecuteSQL knowledge is slowing me down.  Here is my problem.  Under "Manage Database" I have a Service_Management table with several table occurrences used for relationship purposes with one of these occurrences being named "NOC_Dashboard".  On this dashboard layout I am attempting to use eSQL for slice data to a pie chart.  However, before attempting that I wanted to test my eSQL query to see if it would work.  So I created a field on the Service_Management Table, sqlSTATUS (calculation field) using the following statement with the result being text.

       

      ExecuteSQL ("

      SELECT DISTINCT Status

      FROM Service_Management"

      ; "" ; ", ")

       

      Result: WIP, Open, Closed, Cancelled, Pending

       

      I tested this query using the Data Viewer and it returned what I expected.  But, on the NOC_Dashboard layout where I have created an edit box I am still receiving a "?".  The Specify field window I pointed the field to is "Current Table (NOC_Dashboard)::sqlSTATUS"   I do not understand why I am not seeing the same data as in the Data Viewer in this field window.

       

      Please Help.

        1 2 Previous Next