I still wasn't able to get this to work. It doesn't do anything. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Thursday, February 09, 2012 3:04 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
Let's change them a touch...one too many @'s in loop.bat loop.bat @for %%i in (%1) do @call dump %%i dump.bat @echo .separator "," >grocery.sql @echo .output %~n1.csv >>grocery.sql @echo select * from grocery; >>grocery.sql @echo .quit >>grocery.sql @sqlite3 %1 <grocery.sql Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Tim Leland [tlel...@wleeflowers.com] Sent: Thursday, February 09, 2012 1:08 PM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 Haha ya Im "that guy". Ive tried to create these .bat files and they don't seem to do anything. Here they are: Two batch files will do it. loop.bat @for %%i in (%1) do @call @dump %%i dump.bat echo .separator "," >grocery.sql echo .output %~n1.csv >>grocery.sql echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql sqlite3 %1 <grocery.sql loop test?.db You'll then have test1.csv test2.csv test3.csv -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, February 09, 2012 1:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5 On 9 Feb 2012, at 6:28pm, Tim Leland wrote: > That will work but we have to import the sqlite file into our AS400/Iseries > IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My > last resort is just run a script on the PC side that will run sqlite3.exe > shell and convert the sqlite file to a .csv but I want to avoid that step. > If you know of a way for an as400 to import sqlite files that would be > great! Oh, you're that guy. Okay, I'd forgotten your hosting side was on an AS400. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
