Update SQL Lite database from vbscript

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 1 year, 8 months ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts

  • KodiaK
    Member
    #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


    JeremyW
    Moderator
    #271464

    You should be able to invoke the CLI from VBS. https://sqlite.org/cli.html


    Adalberto
    Member
    #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.


    JeremyW
    Moderator
    #271465

    Try specifying the full path to the exe or you can modify the %path% variable to include the directory sqlite3.exe is in.


    Adalberto
    Member
    #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.


    JeremyW
    Moderator
    #271466

    Yes, you would need to install it before you can use it.


    Adalberto
    Member
    #386777

    Unfortunately i can’t do this :(
    So there is no way of doing this without installing a 3rd party application?


    Ossian
    Moderator
    #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)

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.