Update SQL Lite database from vbscript Share on Facebook Tweet on Twitter Share on LinkedIn Home › Forums › Scripting › Windows Script Host › Update SQL Lite database from vbscript This topic contains 7 replies, has 4 voices, and was last updated by Adalberto 2 years, 2 months ago. Viewing 8 posts - 1 through 8 (of 8 total) Author Posts KodiaKMember April 10, 2017 at 7:20 am #166961 Hello, I need to modify a value in a SQL database table from a VBScript, but i don’t know if this can be done without installing a 3rd party sql editor. The SQL command is the following: Update DUTransaction Set commited = 1 where commited = 0[/CODE] And the database file is InstallManifest.sqlite Any help is much appreciated. Thanks[CODE]Update DUTransaction Set commited = 1 where commited = 0[/CODE] And the database file is InstallManifest.sqlite Any help is much appreciated. Thanks JeremyWModerator April 10, 2017 at 12:11 pm #271464 You should be able to invoke the CLI from VBS. https://sqlite.org/cli.html AdalbertoMember April 11, 2017 at 2:49 am #386775 Not working as mentioned there. From CMD “sqlite3” or “sqlite3.exe” is unrecognized command. I think i might be missing a 3rd party application. JeremyWModerator April 12, 2017 at 8:35 am #271465 Try specifying the full path to the exe or you can modify the %path% variable to include the directory sqlite3.exe is in. AdalbertoMember April 13, 2017 at 2:13 am #386776 Don’t you have to install something to have that exe on the machine? Because i can’t find it on a normal W7 machine. JeremyWModerator April 14, 2017 at 7:50 am #271466 Yes, you would need to install it before you can use it. AdalbertoMember April 14, 2017 at 2:41 pm #386777 Unfortunately i can’t do this :( So there is no way of doing this without installing a 3rd party application? OssianModerator April 15, 2017 at 12:18 am #191612 As a bare minimum you will need to install the SQL Lite CMD line tool (appears – from a quick look – to come with the SQL Lite install) Author Posts Viewing 8 posts - 1 through 8 (of 8 total) You must be logged in to reply to this topic.