A question about "case when"
i have the following table
create table test(
id integer primary key,
category text,
rating integer
)
the "rating" column takes value 1 to 5,
I need to get number of 1 to 5 rated records for each category and for
this i used the query,
select
category,
В сообщении от Thursday 10 July 2008 23:04:28 X Wang написал(а):
> Hi, I have a sqlite in-memory databse that I want to periodically dump to a
> disk file (so I can look into its contents at runtime). Currently I
> "ATTACH" an extern file. Periodically I export everything from in-memory
> databse i
В сообщении от Thursday 10 July 2008 20:15:06 Lauri Ojansivu написал(а):
> If you mean making extensions with C, look at the wiki.tcl.tk :
> http://wiki.tcl.tk/_search?_charset_=UTF-8&S=extension
>
> If you mean additional commands or fuctions for SQLite with Tcl, look
> at TkSQLite:
> http://reddo
You can try to help your issue by running "PRAGMA synchronous = OFF;"
after you open your connection.
Cheers,
Shawn Wilsher
Mozilla Developer
On Thu, Jul 10, 2008 at 3:04 PM, X Wang <[EMAIL PROTECTED]> wrote:
> Hi, I have a sqlite in-memory databse that I want to periodically dump to a
> disk f
Hi, I have a sqlite in-memory databse that I want to periodically dump to a
disk file (so I can look into its contents at runtime). Currently I "ATTACH" an
extern file. Periodically I export everything from in-memory databse into the
attached extern file and do a final COMMIT. However, this some
[EMAIL PROTECTED] wrote:
> if( (flags & BTREE_PRIVATE)==0 //FIXME-XXX originally this is
> “&& isMemdb==0” && isMemdb==1
> && (db->flags & SQLITE_Vtab)==0
> && zFilename && zFilename[0] ) // FIXME-XXX
> originally this is strcmp(zFulPathname, …)if(
> 0==strcm
If you mean making extensions with C, look at the wiki.tcl.tk :
http://wiki.tcl.tk/_search?_charset_=UTF-8&S=extension
If you mean additional commands or fuctions for SQLite with Tcl, look
at TkSQLite:
http://reddog.s35.xrea.com/wiki/TkSQLite.html
- Lauri
2008/7/10 Alexey Pechnikov <[EMAIL PROTE
I think it's a problem with [EMAIL PROTECTED]'s e-mail client. All the
messages from him have this problem and it looks like only messages from him
have this problem. I see other messages in the list with C code and no
escaping.
Looking at the raw message I received via the sqlite mailing list f
[EMAIL PROTECTED] wrote:
>
> actually after a quick and dirty hack in btree.c's sqlite3BtreeOpen()
> things _seem_ to work correctly. Of course this is not in any way how it
> should be done, but I didn't see a quick way to give in-memory databases
> a name so that can be used in the search for
On Jul 10, 2008, at 9:28 AM, Shain Lee wrote:
> Don't we have a solution for following problem ?
>
>
>
>
> - Forwarded Message
> From: Shain Lee <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, 10 July, 2008 10:18:07 AM
> Subject: SQL error: database is locked
>
>
> Hi
Don't we have a solution for following problem ?
- Forwarded Message
From: Shain Lee <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, 10 July, 2008 10:18:07 AM
Subject: SQL error: database is locked
Hi
I am using sqlite in Fedora 9. Database created and done every thi
On Jul 10, 2008, at 7:57 AM, Evgeni Alesinskyy wrote:
> Hi all,
>
> I develop application in C# that has to run with MySQL and SQLite.
> At some point I need to join 2 tables and bind them resp. dataset
> containing the union to ListBox.
>
> To do this I use aliasing for table names. My SQL-sta
Hi all,
I develop application in C# that has to run with MySQL and SQLite.
At some point I need to join 2 tables and bind them resp. dataset containing
the union to ListBox.
To do this I use aliasing for table names. My SQL-statement looks like this:
SELECT distinct(m.name), wp.MaterialSN from
Hello!
How can I make tcl lodable extensions? It's possibly on pythone and how about
other languages?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
hi,
actually after a quick and dirty hack in btree.c's sqlite3BtreeOpen()
things _seem_ to work correctly. Of course this is not in any way how it should
be done, but I didn't see a quick way to give in-memory databases a name so
that can be used in the search for existing in-memory databases
hi,
I did some tests with the in-memory database and didn't find any way to use
the in-memory database from multiple db handles in the same process. Having
this capability would enable a multithreaded application to have e.g. multiple
read transactions (each with its own db handle) to run in p
hi,
Just to let you know. I did some more tests, skimmed through the source code.
Here a quick description of how it works:
(1)
If shared cache is disabled, each call to sqlite3_open() will result in a db
handle with its own btree and page cache. If the page cache is not shared, each
db hand
17 matches
Mail list logo