[sqlite] congrats to Will Leshner

2004-06-07 Thread Darren Duncan
Today I discovered (via an article on MacCentral.com) that Will Leshner's company (SQLabs.net) has launched version 1.0 of a commercial client-server database wrapper / generic editor for SQLite, named SQLiteServer. -- Darren Duncan

Re: [sqlite] Triggers & last_inserted_id

2004-06-07 Thread Dennis Cote
Pix wrote: > Suppose I've some tables like these: > > CREATE TABLE contacts (ID, name, surname); > CREATE TABLE oldContacts (ID, name, surname); > CREATE TABLE messages (message, contactID, contactWasDeleted default > NULL); > > I wrote a trigger similar to this: > > CREATE TRIGGER OnDeleteContact

Re: [sqlite] Join query help

2004-06-07 Thread Mitchell Vincent
Really appreciate your help! However that query doesn't give correct results (though it does give a row for every customer!!!).. The problem is the sum() in the join isn't qualified against the selected customer ID.. Using this : SELECT c.customer_number as customer_number

Re: [sqlite] Adding and subtracting decimals is not accurate

2004-06-07 Thread Christian Smith
On Sun, 6 Jun 2004, Raymond Irving wrote: >Hi, > >Is this a problem with all database systems or is it only unique to SQLite? Most database systems have a seperate money type precisely for this problem, which is often BCD to allow arbitrary length values. Rounding errors are simply not an

[sqlite] Median as an aggregate function using the tcl interface

2004-06-07 Thread Detlef Groth
Hello, Is it possible to write the median as an aggregate function using pure tcl. I did the following: package require sqlite sqlite sql d:/data/yaspo2004bt.sqlite sql function median Median set l [list] proc Median {value} { global l lappend l $value # not absolute exact but just a