Hello,
When I use the -init option the .exit statement at the end of my script is
never executed.
I launch sqlite from a batch file on Windows Server 2012 and Windows 7 64 bit.
Command line :
sqlite3.exe -init myscript.scr
myscript.scr :
.log sqlite.log
.bail off
.nullvalue ""
CREATE TABLE STOCKSMAG (
Article TEXT,
CodeDepot TEXT,
QteStock INTEGER,
ECclient INTEGER,
Dispo INTEGER,
ECfour INTEGER,
Proj INTEGER,
DateGen DATETIME,
SeuilReappro INTEGER
);
.import STOCKSMAG.txt STOCKSMAG
.output STOCKSCUMUL.txt
SELECT
Article,
SUM (QteStock) AS QteStock,
SUM (ECclient) AS ECclient,
SUM (Dispo) AS Dispo,
SUM (ECfour) AS ECfour,
SUM (Proj) AS Proj
FROM STOCKSMAG
GROUP BY Article
ORDER BY Article;
.exit
STOCKSMAG.txt :
Article|CodeDepot|QteStock|ECclient|Dispo|ECfour|Proj|DateGen|SeuilReappro
000001|117|0|0|0|0|0|30/08/2018|
000001|118|0|0|0|0|0|30/08/2018|
000001|121|0|0|0|0|0|30/08/2018|
000001|125|0|0|0|0|0|30/08/2018|
Regards,
--
Stéphane Aulery
Développeur
Service informatique
Narbonne Accessoires
04.68.44.16.54
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
