LiveCode Forums.

Yes the command put revOpenDatabase("ODBC","cat", "CatData","","" ) into tDatabaseID will create an integer into tDatabaseID, if the connection is successful. Declare tDatabaseID as a global, and you are good to go to use it into all your scripts. And to close everything, here is a generic script ....

Klaus This completely squares with what I've observed so far. I think before I figured out that revOpenDatabase was going to increment no matter what I did, I was assuming the persistence of the variable because I always got a connection id based on an increment of the previous value and therefore a...

Reply to my question just posted: This is what Neil Roger at RunRev kindly emailed me just now (I was having trouble accessing this forum due to a login snafu so I emailed support earlier): "In regards to the database connection ID, there is no direct way to reset the connection ID that is generated...

Hi. I'm new to LiveCode but not to databases. (using Livecode 5.5.5 on a PC 64 bit, Intel I5, Win8, ODBC with MS Access 2013 and SQLite 3) In my experience, one attempts to reuse database ids to the extent possible, but the revOpenDatabase function seems to increment the id, both in my code and the ...