Re: [sqlite] Regarding redirecting SQL results and errors to a single output file.

2016-06-27 Thread Kaja Varunkumar
44.sql 2>&1 > test44.out > > > -Original Message- > > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > > boun...@mailinglists.sqlite.org] On Behalf Of Kaja Varunkumar > > Sent: Monday, 27 June, 2016 05:28 > > To: sqlite-users@mailingli

Re: [sqlite] Regarding redirecting SQL results and errors to a single output file.

2016-06-27 Thread Kaja Varunkumar
Hello guys, I am able to redirect errors. Can I get queries, where I failed. Thanks, varun On 27 June 2016 at 15:21, Kaja Varunkumar wrote: > Thanks alot > > On 27 June 2016 at 15:13, Simon Davies > wrote: > >> On 27 June 2016 at 10:28, Kaja Varunkumar >> wrote: &

Re: [sqlite] Regarding redirecting SQL results and errors to a single output file.

2016-06-27 Thread Kaja Varunkumar
Thanks alot On 27 June 2016 at 15:13, Simon Davies wrote: > On 27 June 2016 at 10:28, Kaja Varunkumar > wrote: > > Hello, > > > > sqlite -echo test.sqlite < test44.sql > test44.out. > > When I am running above command in windows command prompt, succeed qu

[sqlite] Regarding redirecting SQL results and errors to a single output file.

2016-06-27 Thread Kaja Varunkumar
Hello, sqlite -echo test.sqlite < test44.sql > test44.out. When I am running above command in windows command prompt, succeed query redirected to test44.out and errors are displayed on the command prompt. Here I want all the succeed and failed queries in one file. *EXAMPLE :-* C:\Users\vkaja\Des

[sqlite] Regarding arguments for sqlite in windows bash.

2016-06-26 Thread Kaja Varunkumar
hello, I am new to SQLite. I want to redirect the output to concern file. Output is generated by some SQL file, running it on SQLite I want to redirect it to some file including errors. thanks, varun ___ sqlite-users mailing list sqlite-users@mailinglist

[sqlite] Regarding file extension for sqlite command prompt

2016-06-25 Thread Kaja Varunkumar
Hello, I am new to SQLite, I have seen the commands for command prompt of SQLite. I have some query files with format .sql. Whenever I try to open the files using command .open and read the files . I am getting an error of file encrypted and not in the database. My question's, are there any fo

Re: [sqlite] sqlite3_exec function error:database is locked

2007-10-13 Thread varunkumar
performance. this report generating time depends on what parameters . is it depend on number of rows and size of the database Richard Klein-3 wrote: > >> varunkumar <[EMAIL PROTECTED]> wrote: >>> so two different processes cannot access the database at a time >>>

Re: [sqlite] sqlite3_exec function error:database is locked

2007-10-12 Thread varunkumar
so two different processes cannot access the database at a time John Stanton-3 wrote: > > You need to handle the SQLITE_BUSY condition in your program. > > varunkumar wrote: >> is it possible more than one process can access the sqlite3 database at a >> time? &

[sqlite] sqlite3_exec function error:database is locked

2007-10-12 Thread varunkumar
is it possible more than one process can access the sqlite3 database at a time? I am using sqlite3 database , I have the situation like follows in my project. In my project one process(daemon) doing as follows it is opening the database using sqlite3_open() preparing sqlite3 insert st

[sqlite] sqlite3_exec function error:database is locked

2007-10-09 Thread varunkumar
i am using sqlite3 database in our project in my project one daemon process running , in this daemon process i am opening the data base and inserts the data in to sqlite3database using sqlite3_exec() API . for every one minute i am opening the database and inserts the values in to datab