Re: [sqlite] Segfault on second invalid command

2006-10-06 Thread Jim Dodgen
I do see you problem has gone aways on further emails. the two versions do not interact. SQLite is mostly backward compatible that is you can use newer versions of the software on older versions of the database. But not the reverse. Stephan Brunner wrote: Hi Jim, [description and

Re: [sqlite] Segfault on second invalid command

2006-10-06 Thread Stephan Brunner
Am Donnerstag 05 Oktober 2006 22:25 schrieb Stephan Brunner: > [description and sample perl script for segfault-problem] I've been able to track the issue further down. I moved DBD::SQLite 1.13 away (it has been installed via the cpan shell as a dependency of DBIx::Class) and instead installed

Re: [sqlite] Primay key trait is lost when copying across tables

2006-10-06 Thread Dennis Cote
Carradine wrote: Hello, I am attempting to simply copy a table with data from one database to abother database with the command: attach database 'DB.db3' AS V1 CREATE TABLE Table1 AS SELECT * FROM V1.Table1 The creation of the table, and the copying of the data works great. However, my ID

[sqlite] Primay key trait is lost when copying across tables

2006-10-06 Thread Carradine
Hello, I am attempting to simply copy a table with data from one database to abother database with the command: attach database 'DB.db3' AS V1 CREATE TABLE Table1 AS SELECT * FROM V1.Table1 The creation of the table, and the copying of the data works great. However, my ID field from the

Re: [sqlite] Regarding sqlite3_exec

2006-10-06 Thread He Shiming
Hi List, If I use sqlite3_exec to query a database, How can I know that the results in the data base got over. For example If I am expecting a 10 results in some for loop and actually there are only five results , How can I get a notification or return value that the results completed or Is

Re: Re: [sqlite] database corrouption during power failure

2006-10-06 Thread jayanth KP
Hi Richard, Sorry, i gave a wrong version number of sqlite . We are using sqlite 2.8.13. OBSERVATIONS: - 1) If i call sync() system call after database update, the database is not getting corrupted. 2) In one scenario of corruption sqlite_open() returned an error message "file

Re: [sqlite] Regarding removing create view and some other components in SQLite

2006-10-06 Thread G. Roderick Singleton
On Fri, 2006-10-06 at 12:10 +0530, Vivek R wrote: > Hi List, >we have ported SQLite to one of our consumer products. We require some > minimal applications only like creating and deleting table and Inserting , > Querying, deleting rows in a table. We want to reduce the code size So, We > are

Re: [sqlite] BEGIN TRANSACTION / COMMIT errors

2006-10-06 Thread Jay Sprenkle
On 10/5/06, Levi Wilson <[EMAIL PROTECTED]> wrote: I have a process that opens up a connection to my database when it starts up with sqlite3_open. This connection is kept for the life of the process. In one of my functions, it inserts a row into one table, and also into another table that is

Re: [sqlite] Regarding sqlite3_exec

2006-10-06 Thread Lloyd
I think you are asking for this... This is the case when we use wxSQLite3. wxSQLite3ResultSet result = samp.ExecuteQuery(wxT("select name,age from test")); while (result.NextRow()) { cout << (const char*)(result.GetString(0).mb_str()) << result.GetInt (1)<< endl; } On Fri, 2006-10-06

Re: [sqlite] Regarding removing create view and some other components in SQLite

2006-10-06 Thread drh
"Vivek R" <[EMAIL PROTECTED]> wrote: > Hi List, >we have ported SQLite to one of our consumer products. What consumer product? Who do you work for? > We require some > minimal applications only like creating and deleting table and Inserting , > Querying, deleting rows in a table. We want

[sqlite] Regarding sqlite3_exec

2006-10-06 Thread Vivek R
Hi List, If I use sqlite3_exec to query a database, How can I know that the results in the data base got over. For example If I am expecting a 10 results in some for loop and actually there are only five results , How can I get a notification or return value that the results completed or Is

[sqlite] EXISTS subcommand. was: Wiki is locked

2006-10-06 Thread drh
Arjen Markus <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > > > > >Whatever > > > >Everything appears to be working now. > > > > > Yes, I can see the contents now. As we are on the subject of documentation, > someone on the Tclers' chat mentioned that the subcommand "exists" is

Re: [sqlite] Wiki is locked

2006-10-06 Thread Arjen Markus
[EMAIL PROTECTED] wrote: Whatever Everything appears to be working now. Yes, I can see the contents now. As we are on the subject of documentation, someone on the Tclers' chat mentioned that the subcommand "exists" is documented, but not actually implemented. Could you have a look at

Re: [sqlite] Wiki is locked

2006-10-06 Thread drh
Arjen Markus <[EMAIL PROTECTED]> wrote: > Hello, > > I tried to access the SQLite Wiki this morning (MET 8:30), but all I got > was a reply > that the query failed because the database was locked. > > Can somebody (Richard Hipp most probably) look into this? > This problem appears to have

Re: [sqlite] database corrouption during power failure

2006-10-06 Thread drh
"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi, >I have a question regarding power failure handling in sqlite 2.8.3. > > When the power is switched off during a database write like (insert/update), > in next reboot database is getting corroupted. > > The database is in a ext3 partition on

[sqlite] database corrouption during power failure

2006-10-06 Thread jayanth KP
Hi, I have a question regarding power failure handling in sqlite 2.8.3. When the power is switched off during a database write like (insert/update), in next reboot database is getting corroupted. The database is in a ext3 partition on the harddisk (linux 2.6). Also i tried the

[sqlite] test mail - plz ignore

2006-10-06 Thread jayanth KP

Re: [sqlite] Segfault on second invalid command

2006-10-06 Thread Stephan Brunner
Hi Jim, >> [description and sample perl script for segfault-problem] > This might be related to DBD::SQLite 1.13 defaulting to SQLite 3.3.7? > I tend to try and keep my PERL and SQLite Command line at the same > version. How do the two (commandline-version and DBD::SQLite) interact? The only

[sqlite] Regarding removing create view and some other components in SQLite

2006-10-06 Thread Vivek R
Hi List, we have ported SQLite to one of our consumer products. We require some minimal applications only like creating and deleting table and Inserting , Querying, deleting rows in a table. We want to reduce the code size So, We are planning to remove some of the features like create view and

[sqlite] Wiki is locked

2006-10-06 Thread Arjen Markus
Hello, I tried to access the SQLite Wiki this morning (MET 8:30), but all I got was a reply that the query failed because the database was locked. Can somebody (Richard Hipp most probably) look into this? Regards, Arjen