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

douglaschong — Wed, 04 Mar 2020 16:21:52 GMT

Steps to reproduce:

Run any new sql query:

query << Run Foreground(
	OnRunComplete(
		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.

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

Gerry_R — Wed, 21 Oct 2020 18:30:10 GMT

I have exactly this same question. I have a database that does not deal well with non-terminated connections and can't always use Open Database Connection()/Close Database Connection with a DSN name..if I use an ODBC:driver string, I have to use New SQL Query, but I don't see a way to close it when finished.

topic Re: How to close database connection after running a New Sql Query? in Discussions

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

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