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
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
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
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
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
5 matches
Mail list logo