Run SQL commands through Notepad++

[cloudytechi147]

I am trying to start out using Notepad++ to run SQLite commands. I have tried following two brief YouTube tutorials to get me going. I can run the initial .bat file but still cannot run the .sql file.

I have a Windows system environment Path variable set to the folder containing sqlite3.exe

"C:\Users\Adam\sqlite\"

I have saved the following file RunSQLite.bat in the folder containing sqlite3.exe

sqlite3.exe testDB.db

I have created a second file queries.sql

SELECT 34;

When I try to run queries.sql from Notepad++, using the RUN command:

C:\Users\Adam\sqlite\RunSQLite.bat "$(FULL_CURRENT_PATH)"

the only file that appears to run is RunSQLite.bat, giving the output:

SQLite version 3.36.0 2021-06-18 18:36:39 Enter ".help" for usage hints. sqlite>

Can anyone tell where I have gone wrong?

Thanks in advance.




---------------------------------------------
This was the C Interview Questions.

 

[CodeMonkeyJ]

Judging by the "sqlite>" at the end, it's dropping into a SQLite shell instead of running the SQL file. I also don't see where you're using the argument you're passing to the batch file. Try changing your SQLite command to the following.

sqlite3.exe testDB.db -init %1