Re: [sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

2008-01-13 Thread Luc DAVID
Thanks for your answer, I don't have time to test it now but I will let you know. I 'm not on my linux machine but I believe gcc -c sqlite3.c generates a sqlite3.o file. Is this file already usable as a shared library or do I have to call the linker to generate a sqlite3.so ? How can I check

Re: [sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

2008-01-13 Thread Luc DAVID
I found some answer to my previous questions and wrote a short tutorial at http://source.online.free.fr/Linux_HowToCompileSQLite.html I still have two points to solve How can I check the functions available in the sqlite3 shared library ? Are there some tools available to list the functions

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Darren Duncan
At 9:07 PM -0500 1/12/08, D. Richard Hipp wrote: In case you haven't been watching the timeline (http://www.sqlite.org/cvstrac/timeline) we are in the middle of some major changes. The virtual machine inside of SQLite is being transformed from a stack-based machine into a register-based machine.

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Rich Shepard
On Sun, 13 Jan 2008, Darren Duncan wrote: I would think something like that is worthy of a 3.6.0 version number. Not just a minor version increase that would be more suitable for minor changes or bugfixes. I agree with Darren that massive changes to the core of the system should be

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Marco Bambini
What will be the main benefits of the new virtual machine? I mean, it will be just faster or there will be other improvements in the library? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 13, 2008, at 3:07 AM, D. Richard

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread D. Richard Hipp
On Jan 13, 2008, at 11:31 AM, Rich Shepard wrote: On Sun, 13 Jan 2008, Darren Duncan wrote: I would think something like that is worthy of a 3.6.0 version number. Not just a minor version increase that would be more suitable for minor changes or bugfixes. I agree with Darren that

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread D. Richard Hipp
On Jan 13, 2008, at 11:40 AM, Marco Bambini wrote: What will be the main benefits of the new virtual machine? Optimizations such as common subexpression elimination and moving subexpressions outside of inner loops will become much easier. The code generator will, in general, be easier to

[sqlite] wxgrid fed with sqlite

2008-01-13 Thread sqlfan
has anyone fed an editable wxgrid with sqlite? -- View this message in context: http://www.nabble.com/wxgrid-fed-with-sqlite-tp14790059p14790059.html Sent from the SQLite mailing list archive at Nabble.com. - To

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Joe Wilson
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > There are people on this mailing list (ex: Joe Wilson) who appear > to read every line of every change that we make to SQLite, within > minutes of making them, and complain if we so much as misspell a > word in a comment. And I haven't heard a

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Gerry Snyder
Joe Wilson wrote: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: There are people on this mailing list (ex: Joe Wilson) who appear to read every line of every change that we make to SQLite, within minutes of making them, and complain if we so much as misspell a word in a comment. And I

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread P Kishor
On 1/13/08, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > > There are people on this mailing list (ex: Joe Wilson) who appear > > to read every line of every change that we make to SQLite, within > > minutes of making them, and complain if we so much as

Re: [sqlite] Re: How do I do this

2008-01-13 Thread Vishal Mailinglist
Hi , I knew I was not explaining better. > sno | id | amount > > 1| 1 | 200 > > 2| 1 | 300 > > 3 | 2 | 100 > > 4 | 2 | 100 > > 5 | 1 | 500 > > > > how could I subtract the sno 1 id 1 and sno 2 id 1 amount . > > select > (select amount from tableName where sno=1 and id=1) - >

Re: [sqlite] Re: How do I do this

2008-01-13 Thread miguel manese
On Jan 14, 2008 9:09 AM, Vishal Mailinglist <[EMAIL PROTECTED]> wrote: > > sno | id | amount > > > 1| 1 | 200 > > > 2| 1 | 300 > > > 3 | 2 | 100 > > > 4 | 2 | 100 > > > 5 | 1 | 500 > What if I do not have control over sno i.e it is random or unpredictable , > I want to subtract it in

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread D. Richard Hipp
On Jan 13, 2008, at 7:53 PM, Gerry Snyder wrote: Joe Wilson wrote: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: There are people on this mailing list (ex: Joe Wilson) who appear to read every line of every change that we make to SQLite, within minutes of making them, and complain if

[sqlite] Re: Re: How do I do this

2008-01-13 Thread Igor Tandetnik
Vishal Mailinglist wrote: Hi , I knew I was not explaining better. sno | id | amount 1| 1 | 200 2| 1 | 300 3 | 2 | 100 4 | 2 | 100 5 | 1 | 500 how could I subtract the sno 1 id 1 and sno 2 id 1 amount . select (select amount from tableName where sno=1 and id=1) -

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Rick Langschultz
I was wondering what would constitute the creation of SQLite 4.0? Since the VDBE is being revamped I would consider this a pretty big revamp of the SQLite code. I am looking forward to testing this out new engine out. I also wanted to know what the difference between stack based and

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Darren Duncan
At 8:46 PM -0600 1/13/08, Rick Langschultz wrote: I was wondering what would constitute the creation of SQLite 4.0? Since the VDBE is being revamped I would consider this a pretty big revamp of the SQLite code. I am looking forward to testing this out new engine out. I also wanted to know

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Bill KING
A colleague brought up a very good point. At least for the first few revisions, is the old engine/code still going to be available until the new engine code base settles down? (via #defines maybe?). It would lead towards a good chance of comparison between the two engines too for people. D.

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rick Langschultz wrote: > I was wondering what would constitute the creation of SQLite 4.0? An incompatible API, or significant behaviour changes. > Since the VDBE is being revamped I would consider this a pretty big > revamp of the SQLite code.

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Joe Wilson
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Sorry for the confusion. No problem. For what it's worth, I am also curious as to the final form of the VM opcode transformation. The number of opcodes generated by the various SQL statements seems to be roughly the same as the old scheme. At

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Jim Dodgen
this was a true complement and nothing else. P Kishor wrote: On 1/13/08, Joe Wilson <[EMAIL PROTECTED]> wrote: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: There are people on this mailing list (ex: Joe Wilson) who appear to read every line of every change that we make to SQLite,

[sqlite] Reasons for query execution(C library) to fail?

2008-01-13 Thread Benjamin Fuller
I was wondering what possible reasons the following query to fail on a certain code path but not from another. When I check the database after this function is called, from a one code path the database updates, from the other code path the database does not update. Important to note is that in

Re: [sqlite] SQL error: database disk image is malformed

2008-01-13 Thread jose isaias cabrera
"Kees Nuyt" trying to help me said... On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera" <[EMAIL PROTECTED]> wrote: Greetings. I have a problem. I have this shared DB amongst 4 co-workers where I am getting this error: SQL error: database disk image is malformed that is after I

[sqlite] help with sql query / command SUM

2008-01-13 Thread Jorge Pereira
Hi folks! I Have two tables, and i need access data from both. below it's my tables; CREATE TABLE Product ( CD_PROD INTEGER CONSTRAINT PK_PROD NOT NULL PRIMARY KEY AUTOINCREMENT, CD_REMT_COMM INTEGER CONSTRAINT FK_PROD_REMT_COMM REFERENCES Remote_command(CD_REMT_COMM),