346880_en-US

liliconcom

Execute SQL ignores output if not a table

I can connect to a SQL server with JMP to extract tables.

 

The problem I have is that if I execute a SQL command that prints a single value (e.g. current datetime from the database), I am unable to get it as a string.

 

I am using:

Execute SQL()

https://www.jmp.com/support/help/en/15.2/index.shtml#page/jmp/sql-functions.shtml

 

ScriptingRe: Execute SQL ignores output if not a tableMaybe you can output a table instead of print in SQL query.