UNQLITE and %_unq_db

[Joe Caverly]

     _x64: 1
   _admin: 1
_elevated: 1

TCC  27.00.21 x64   Windows 10 [Version 10.0.19042.867]

When I close an UNQLITE database, %_unq_db still returns the name of the current database.

@setlocal
@echo off

set thedb=jlc.db

echo Opening database for read/write/create
unqlite /db:"%thedb" /rwc

echo Name of current database: %_unq_db

unqlite /db:"%thedb" /kvs "keyone" "This is a string value assigned to keyone"

unqlite /db:"%thedb" /r "keyone"

echo Closing the database
unqlite /c

echo Name of current database: %_unq_db

endlocal
quit

e:\utils>testun
Opening database for read/write/create
Name of current database: E:\Utils\jlc.db
Closing the database
Name of current database: E:\Utils\jlc.db

Should %_unq_db still be returning the name of the current database, even though I have closed the database?

Joe

 

[rconn]

Yes, because if you don't specify a database name, the UNQLITE command will default to using the most recent one (which is saved in _unq_db). If _unq_db was cleared on a close, this feature would break.

 

[Joe Caverly]

Thanks Rex. I missed it previously, but I do see your reference in the help file;

If this option is omitted, UNQLITE will use the last database name (if any).

Joe