1 2 Previous Next 15 Replies Latest reply on Apr 18, 2017 7:21 AM by beverly

    ExecuteSQL and Table Occurrences

    DanielShanahan

      FWIW: I just discovered that the FROM clause in ExecuteSQL requires the table to be on the relationship graph. I was stumped why my simple SQL statement wouldn't work (returned a "?"). I tried reserved words, escaped quotes, etc. Then I discoved that my table name was not in the relationship graph. If I used a table occurrence my SQL statement worked. Likewise, if I added a table occurrence of just the table name, the statement worked.

        1 2 Previous Next