[sqlite] Problem creating TRIGGER

Hi! I am very new to sqlite. I am having problem creating a trigger. Here is the statement: - sqlite> CREATE TRIGGER dat.on_master_insert INSERT ON dat.master_table FOR EACH ROW BEGIN INSERT INTO dat.url_stats(new.file_name, '0', '0', '1'); END; SQL error: near ".": syntax error The problem

[sqlite] Problem creating TRIGGER

Hi! I am very new to sqlite. I am having problem creating a trigger. Here is the statement: - sqlite> CREATE TRIGGER dat.on_master_insert INSERT ON dat.master_table FOR EACH ROW BEGIN INSERT INTO dat.url_stats(new.file_name, '0', '0', '1'); END; SQL error: near ".": syntax error The problem

Re: [sqlite] problem with queries using group by

On Fri, 14 Jan 2005 18:15:04 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Tiago Dionizio wrote: > > > Hi, > > > > I am using a recent copy from CVS and tried this: (sorry for the quick > > and dirty test) > > > > SQLite version 3.0.8 > > Enter ".help" for instructions > > sqlite> create

Re: [sqlite] problem with queries using group by

Tiago Dionizio wrote: Hi, I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test) SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used

Re: [sqlite] sql tables. . .?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Here's a question. I'm doing a file table with ( path text, name text, ... ) And I know definitely I'll want to search for "name" where /usr/lib/libgtk.so is name=libgtk.so Now for path, will I ever care to search for '/usr/lib/'? Or would

[sqlite] problem with queries using group by

Hi, I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test) SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used on aggregate queries

Re: [sqlite] SQLite openning a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christian Smith wrote: > On Fri, 14 Jan 2005, John Richard Moser wrote: > >>-BEGIN PGP SIGNED MESSAGE- >>Hash: SHA1 >> >> >> >>D. Richard Hipp wrote: >> >> >>>I don't *think* this is a problem. But version 3.1 will contain >>>extra

Re: [sqlite] OT: Compiling under Windows

All, What do you mean with "Multithreaded" or "Mulithreaded-DLL" project? Can you explain exactly where you can select between these two options, and whether you are using Visual Studio 6 or 2002/2003? Sorry for being not "precise" enough - english isn't my native language so it's sometimes