Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Mihai Militaru
On Sat, 23 Apr 2011 19:06:02 +0200 Roger Andersson wrote: > > On Unices I use: "sqlite3.exe default.db3< schema.sql" as exemplified by > > DRH (IIRC), but I guess > > there's no way to do something similar on Windows cmd? > > > Have you tried exactly the same on Windows cmd? I'm sorry for the

Re: [sqlite] data issues on iPhone

2011-04-23 Thread Simon Slavin
On 24 Apr 2011, at 1:49am, Mickey Mestel wrote: > if i then shut down the app and restart it, the data is retrieved with > no issues. > > so basically a connection is made to the database, the table is created > if it doesn't exist, we go through a loop of processing JSON data read

[sqlite] data issues on iPhone

2011-04-23 Thread Mickey Mestel
hi all, we are using sqlite on the iPhone, in conjunction with SQLCipher, so the sqlite version is compiled in with SQLCipher. the version of sqlite is 3.7.2, and 4.3 of iOS. i have an issue that suddenly started appearing all of a sudden. what is happening is that the data i

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Random Coder
On Fri, Apr 22, 2011 at 8:18 AM, Maurice Marinus wrote: > On a windows platform I have the following: > schema.sql (contains the sql scripts) > sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) > build.bat : A batch file containing the line : sqlite3.exe -init > schema.sql defau

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Roger Andersson
On 04/23/11 06:50 PM, Mihai Militaru wrote: > On Sat, 23 Apr 2011 12:17:54 -0400 > Tom Holden wrote: > > On Unices I use: "sqlite3.exe default.db3< schema.sql" as exemplified by DRH > (IIRC), but I guess > there's no way to do something similar on Windows cmd? > Have you tried exactly the same

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Simon Slavin
On 22 Apr 2011, at 4:18pm, Maurice Marinus wrote: > When I run build.bat, the database is created as expected, however, the > sqlite shell doesn't automatically terminate. So how would I get the > batch file to run and terminate the sqlite command shell automatically? > > Output shown on the d

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Mihai Militaru
On Sat, 23 Apr 2011 12:17:54 -0400 Tom Holden wrote: > Perhaps by adding > .quit > to your schema.sql I tried this and it does not work, no error but it enters interactive mode once more. Also, the necessity to add sqlite shell commands to the file would pervert the pure SQL schema if it worke

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Tom Holden
Perhaps by adding .quit to your schema.sql Tom -Original Message- From: Maurice Marinus Sent: Friday, April 22, 2011 11:18 AM To: sqlite-users@sqlite.org Subject: [sqlite] Automating the build of a sqlite database So how would I get the batch file to run and terminate the sqlite c

Re: [sqlite] how to reuse a prepared statement

2011-04-23 Thread Teg
I got bit by this the other day. I typically just used "reset" but, if you have a case where you're looping through an insert and you don't always set all values (say a string is empty sometimes so, you forgo the bind), the previous value set will get inserted where you expected blanks to go. Cle

Re: [sqlite] how to reuse a prepared statement

2011-04-23 Thread Mihai Militaru
On Sat, 23 Apr 2011 09:39:40 -0400 Sam Carleton wrote: > Can someone then explain the purpose of sqlite3_clear_bindings()? If > I understand things correctly, you call sqlite3_reset() to reuse a > prepaired statement, why do you call sqlite3_clear_bindings()? Is it > because sqlite3_reset() do

Re: [sqlite] how to reuse a prepared statement

2011-04-23 Thread Igor Tandetnik
Sam Carleton wrote: > On Fri, Apr 22, 2011 at 11:44 PM, Drake Wilson wrote: > >> You probably need to sqlite3_reset the statement after stepping it. > > Can someone then explain the purpose of sqlite3_clear_bindings()? sqlite3_reset preserves previous bindings. sqlite3_clear_bindings resets a

Re: [sqlite] how to reuse a prepared statement

2011-04-23 Thread Sam Carleton
On Fri, Apr 22, 2011 at 11:44 PM, Drake Wilson wrote: > You probably need to sqlite3_reset the statement after stepping it. Can someone then explain the purpose of sqlite3_clear_bindings()? If I understand things correctly, you call sqlite3_reset() to reuse a prepaired statement, why do you ca

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Igor Tandetnik
Maurice Marinus wrote: > On a windows platform I have the following: > schema.sql (contains the sql scripts) > sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) > build.bat : A batch file containing the line : sqlite3.exe -init > schema.sql default.db3 > > When I run build.bat,

[sqlite] Automating the build of a sqlite database

2011-04-23 Thread Maurice Marinus
On a windows platform I have the following: schema.sql (contains the sql scripts) sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) build.bat : A batch file containing the line : sqlite3.exe -init schema.sql default.db3 When I run build.bat, the database is created as expected,