Welcome to the JMP User Community!

Latest Discussions

• How to check if "Create Database Connection" is successful?

  Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to:1. Be connected to internal network OR have VPN on2. Have ODBC source set up correctly Sometimes they don't. I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a val...

  miguello

  Discussions |

  Sep 5, 2019 8:40 AM

  2302 views | 2 replies

• How to plot a normal curve on a histogram

  Back in 2017, txnelson posted a nice snippet of code to do this:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); Dis = dt << Distribution( Continuous Distribution( Column( :height ), Vertical( 0 ), Density Axis( 1 ) ) ); Report( Dis )[Frame Box( 2 )] << Add Graphics Script( mu = 63; sigma = 3.2; Pen Color( "Red" ); Y Function( Normal Density( (x - mu) / sigma ) / (40 /...

  speleogen

  Discussions |

  Sep 5, 2019 8:21 AM

  1973 views | 1 replies

• JMP, LIMS, SPC & some stability analysis

  Maybe this is a long shot, but I thought I'd post it anyway. After a very productive 1h meeting with a JMP systems engineer last week I started suspecting that JMP at my workplace is highly underutilized. Partly this has historical reasons, as it is a young company, where the use of Excel proliferated for all purposes from logging process measurement data to stability & degradation analysis of fin...

  Ressel

  Discussions |

  Sep 5, 2019 7:19 AM

  11176 views | 8 replies

• Sending OBDC Data Source connection with Add-in or Creating it through JSL

  Hi all,  I am trying to create an Add-in that pulls data from an SQL Server as data source, and I would need to distribute this Add-in to other users. The Add-in works perfectly, but the OBDC connection used by the Add-in is not being sent with it. Unfortunately, not everyone would be able/know how to create an OBDC connection to the SQL server in an easy way.  Does anyone know how I could either ...

  A_J

  Discussions |

  Sep 5, 2019 7:09 AM

  3375 views | 3 replies

• Getting a data table reference from NewSQLQuery() << Run Background with Names Default to Here(1);

  I'm having trouble getting the data table reference if I run in the background.  Anyone know how to get around this?     names default to here(1); sql_query = New SQL Query( Connection( "ODBC:DSN=Test Source;DATABASE=Test;" ), QueryName( "Thingy" ), Select( blah ), From( other blah ) ); sql_query << Run Background( OnRunComplete( dt = queryResult; dt = data table(queryResult<<G...

  vince_faller

  Discussions |

  Sep 4, 2019 6:01 AM

  9941 views | 7 replies