ExecuteSQL and Table Occurrences

Discussion created by DanielShanahan on Sep 18, 2013
Latest reply on Apr 18, 2017 by beverly

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.