Cannot run sqlite3 from command prompt on 6.0.1

[Connor Armstrong]

We recently upgraded to 6.0.1 from 5.7.  We use sqlite3 to access a few sqlite databases.  When we try to run sqlite3 from the command prompt, we can an error “‘sqlite3’ is not recognized as an internal or external command, operable program or batch file”.

We have xlates and tclprocs that use sqlite3 and they are working correctly.

Code in tclproc:

   load tclsqlite3.dll sqlite3

   sqlite3 db hin_docs.sqlite

   set hin_doc [db eval {select doc_alias from hin_docs where doc_alias = $mill_doc_alias}]

I have attached a screen shot of what we get when we run sqlite3 from the command prompt.  On CL 5.7 using sqlite3 as in the screenshot worked fine.

Is there something we’re missing to get sqlite3 working from the command prompt or is it no longer available?  If we use sqlite, we can access the databases so we’re confused why sqlite3 works from the tclprocs and xlates but not the command prompt.

Connor[/img]

Topic

[Max Drown (Infor)]

SQLite is now packaged with Cloverleaf. This means that you no longer need to load SQLite. You should reference SQLite with “sqlite” from now on.

Please see this thread for some examples: https://usspvlclovertch2.infor.com/viewtopic.php?t=6686

-- Max Drown (Infor)

[Connor Armstrong]

Thank you Max!

[Author]

Replies