(The error message that I am receiving is: The column named "EmployeeName" does not exist in table "PP1").
How do you get any error message at all back from ExecuteSQL?
Aaah - that is a bit tricky!
(1) Create a custom Function called "SqlDebug" ... Source code is listed here => http://www.fmfunctions.com/fid/335
Note, the function is only 3 lines long (very very basic), but you must have FM Pro Advanced to use custom functions
(2) Open "data viewer" and paste your ExecuteSql statement into a new WATCH window
(3) Enclose the entire ExecuteSQL statement inside of the SqlDebug function, like so:
SqlDebug ( ExecuteSql ( "Select Statements Here" ; "" ; "" ) )
(4) Now click "Monitor"
(5) The error will be displayed in the VALUE column.
(6) Open the same function for editing, and the full error message will appear in the RESULT window
Example in attached image:
Thanks! that one's a real keeper!
I suggest posting over in Report an Issue to see what the TS personnel think about this issue. You can save typing by posting a link to here in order to describe the issue.
not a bug
admittedly, not the missing feature you want to use either , but not a bug.