- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to close database connection after running a New Sql Query?
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.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to close database connection after running a New Sql Query?
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.