Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Level I

How to close database connection after running a New Sql Query?

Steps to reproduce:


Run any new sql query:


query << Run Foreground(
		Write( "Number of rows in query result: ", N Rows( queryResult ) )

MyRunCompleteFunc = Function( {dt},
	{Default Local},
	Write( "Number of rows in query result: ", N Rows( dt ) )
query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );

Next, if you try to delete the database, it will say that jmp is still using the database.


Is there a way to close the database connection? The function Close Database Connection() does not seem to do the trick.


Article Labels

    There are no labels assigned to this post.