I have a working SQL query using the New SQL Query () function. When I first open this with JMP is works perfectly, however when I try to "Update Database" or "Modify Query", neither work. I've noticed it is because the Connection () function appears to disappear after first use which is unusual. This problem has only just occurred after 3 or 4 days, as it was fine before this and I could update the database as much as I wanted. A colleague has had the same issue of it working then suddenly it's only single-use. My first though is that the connection has some sort of lifetime which it seems to have surpassed but if so, that's quite annoying as it means I have to manually copy-paste the connection function each time I want to update the datatable. Below is the connection example (details changed for privacy):
Names Default To Here( 1 );
New SQL Query(
Connection(
"ODBC:BI=0;BoolsAsChar=1;ByteaAsLongVarBinary=1;CommLog=0;DATABASE=database;DSN=PostgreSQL30;Debug=0;FakeOidIndex=0;Fetch=100;LFConversion=1;LowerCaseIdentifier=0;MaxLongVarcharSize=8190;MaxVarcharSize=255;PORT=1111;PWD=%_PWD_%;Parse=0;Protocol=7.4;ReadOnly=0;RowVersioning=0;SERVER=11.111.11.111;SSLmode=disable;ShowOidColumn=0;ShowSystemTables=0;TextAsLongVarchar=1;TrueIsMinus1=0;UID=username;UnknownSizes=0;UnknownsAsLongVarchar=0;UpdatableCursors=1;UseDeclareFetch=0;UseServerSidePrepare=1;XaOpt=1;"
),
QueryName( "name of query" ),
CustomSQL(
query_here
)
);
