Here's exactly what I did. You get a different result?
sqlite3 test1.db
create table grocery(a int,b int);
insert into grocery values(1,2);
insert into grocery values(2,3);
.quit
copy test1.db test2.db
copy test1.db test3.db
At this point I have:
02/11/2012 06:53 AM 228 dump.bat
02/11/2012 06:42 AM 49 loop.bat
02/11/2012 06:48 AM 2,048 test1.db
02/11/2012 06:48 AM 2,048 test2.db
02/11/2012 06:48 AM 2,048 test3.db
loop test?.db
Then I have
02/11/2012 06:53 AM 228 dump.bat
02/11/2012 06:54 AM 70 grocery.sql
02/11/2012 06:42 AM 49 loop.bat
02/11/2012 06:54 AM 8 test1.csv
02/11/2012 06:48 AM 2,048 test1.db
02/11/2012 06:54 AM 8 test2.csv
02/11/2012 06:48 AM 2,048 test2.db
02/11/2012 06:54 AM 8 test3.csv
02/11/2012 06:48 AM 2,048 test3.db
9 File(s) 6,515 bytes
2 Dir(s) 201,627,729,920 bytes free
D:\SQLite\xx>more test1.csv
1,2
2,3
Using these two batch files
loop.bat
@for %%i in (%1) do @call dump %%i
dump.bat
@del /q %~n1.csv
@if not exist %1 echo No such file: %1
@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 <grocery.sql
What happens to you?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: [email protected] [[email protected]] on
behalf of Tim Leland [[email protected]]
Sent: Friday, February 10, 2012 2:03 PM
To: 'General Discussion of SQLite Database'
Subject: EXT :Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
I still wasn't able to get this to work. It doesn't do anything.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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: [email protected] [[email protected]] on
behalf of Tim Leland [[email protected]]
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: [email protected]
[mailto:[email protected]] 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
