On Thursday, July 01, 2010 9:56 PM, Miha Vrhovnik wrote:
It's time to get rid of your current e-mail client ...
... and start using si.Mail.
It's small free. ( http://www.simail.si/ )
A nice little advert and out of curiosity I went to the website and had a
little look around. I assume
Am 02.07.2010 00:40, schrieb Simon Slavin:
On 1 Jul 2010, at 11:56am, Daniel Jung wrote:
My problem: I wrote a simple program in c-sharp. This program does
refers to a sqlite database. The program is in my auto boot so it shall
run by starting by pc. But every time the is an exception
Daniel -- you need to give more info
C#'s exception messages are terrible and very non-specific as they simply
indicate failure and not why.
Use the C function fopen() to test your database file.
If you get an error back In your simple program display a dialog box with the
I think -csv is, in essence, just a shorthand for -separator ,
So in your first example you override it your semicolon with the -csv option.
Not a bug at all unless you think it should warn you every time you change the
separator (which would seem a bit much).
Michael D. Black
Senior
On 2 Jul 2010, at 9:26am, Daniel wrote:
My problem: I wrote a simple program in c-sharp. This program does
refers to a sqlite database. The program is in my auto boot so it shall
run by starting by pc. But every time the is an exception that the
database could not be opened. I have no idea
Great thanks.
Now why didn't I think of that especially as I was messing around with ROWID
earlier?
Cheers
update TABLE2 set z = @z
where rowid in (
select t2.rowid
from TABLE1_2 t12, TABLE2 t2
where t12.a = @a
and t12.b = @b
and t2.x = t12.x
and t2.y = t12.y
)
Pavel
Hi,
SELECT DISTINCT type_id FROM foods;
If I use 'distinct', any entry that shows up greater or equal to one
time will only appear once. But I want to select an entry that appears
=n times and only show n times if it appears more than n times. I
think that group by might help. But I'm not
On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu pengyu...@gmail.com wrote:
Hi,
SELECT DISTINCT type_id FROM foods;
If I use 'distinct', any entry that shows up greater or equal to one
time will only appear once. But I want to select an entry that appears
=n times and only show n times if it
On Fri, Jul 2, 2010 at 11:19 AM, P Kishor punk.k...@gmail.com wrote:
On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu pengyu...@gmail.com wrote:
Hi,
SELECT DISTINCT type_id FROM foods;
If I use 'distinct', any entry that shows up greater or equal to one
time will only appear once. But I want to
On Fri, Jul 2, 2010 at 11:19 AM, P Kishor punk.k...@gmail.com wrote:
On Fri, Jul 2, 2010 at 11:19 AM, P Kishor punk.k...@gmail.com wrote:
On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu pengyu...@gmail.com wrote:
Hi,
SELECT DISTINCT type_id FROM foods;
If I use 'distinct', any entry that shows up
I don't know about anybody else but I can't tell what you want to do.
Have you got some sample data and the results you expect from it?
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
From: sqlite-users-boun...@sqlite.org on behalf of
Maybe this?
SELECTwhatever column, min(Count(type_id),n)
FROM foods
GROUP BYwhatever column
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
But this doesn't show anything that count more than n times. I want
the type_id shows up more than n times in the database only appear n
times in the result of the query.
That's some exotic requirements you've got there. Is it possible to
elaborate them? Probably your best solution is not in
On Fri, Jul 2, 2010 at 11:35 AM, Black, Michael (IS)
michael.bla...@ngc.com wrote:
I don't know about anybody else but I can't tell what you want to do.
Have you got some sample data and the results you expect from it?
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
Ämne: [sqlite] problem with auto boot
Hi,
no idea if it's the right way or place but I have a question
about the sqlite database. I did not found any solution in
other forums or by using google.
My problem: I wrote a simple program in c-sharp. This program
does refers to a sqlite
On 2 Jul 2010, at 5:15pm, Peng Yu wrote:
I want to select an entry that appears
=n times and only show n times if it appears more than n times. I
think that group by might help.
There's no simple format which will do what you want. Do it in software.
Simon.
Are you thinking of limit?
On 7/2/2010 9:58 AM, Simon Slavin wrote:
On 2 Jul 2010, at 5:15pm, Peng Yu wrote:
I want to select an entry that appears
=n times and only show n times if it appears more than n times. I
think that group by might help.
There's no simple format which
P Kishor punk.k...@gmail.com wrote:
I think what Peng wants is that given table of type_id
5
5
5
5
5
4
4
4
7
7
8
8
8
8
if 'n' is 3, the desired result is
5
5
5
4
4
4
7
7
8
8
8
I don't know how to do that with sql.
Well, if you insist:
select type_id from foods
On 2 Jul 2010, at 6:06pm, Igor Tandetnik wrote:
select type_id from foods f1
where (
select count(*) from foods f2
where f2.type_id = f1.type_id
and f2.rowid f1.rowid) 3;
Clever.
Simon.
___
sqlite-users mailing list
On Fri, Jul 2, 2010 at 12:06 PM, Igor Tandetnik itandet...@mvps.org wrote:
P Kishor punk.k...@gmail.com wrote:
I think what Peng wants is that given table of type_id
5
5
5
5
5
4
4
4
7
7
8
8
8
8
if 'n' is 3, the desired result is
5
5
5
4
4
4
7
7
8
8
8
I don't know
Hi all, I'm a beginner user of this tool. I have to questions.
What would be the better approach to multithread support for sqlite using C++
API?
I'm currently try to block, using boost mutex, locks and condition variables,
all calls to step method that attempts to modify the DB.
Sqlite
Peng Yu pengyu...@... writes:
Hi,
SELECT DISTINCT type_id FROM foods;
If I use 'distinct', any entry that shows up greater or equal to one
time will only appear once. But I want to select an entry that appears
=n times and only show n times if it appears more than n times. I
think
Igor Tandetnik itandet...@mvps.org wrote:
P Kishor punk.k...@gmail.com wrote:
I think what Peng wants is that given table of type_id
5
5
5
5
5
4
4
4
7
7
8
8
8
8
if 'n' is 3, the desired result is
5
5
5
4
4
4
7
7
8
8
8
I don't know how to do that with sql.
o.k.,
got it - next time I'll read twice (at least ;-) )
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 2 Jul 2010, at 6:14pm, Cargnelutti, Pablo Fernando wrote:
Sqlite implements table level lock?
No. SQLite locks the entire database file with all tables and views in it.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 7/2/2010 10:09 AM, P Kishor wrote:
I was going to add That is an Igor-question to I don't know how to
do that with sql. I have no idea how you do this, but if ever I meet
you in person, I will be too awestruck to say anything beyond
SELECT..
From me it would more likely be an irate
Another +1 on the awestruck!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I think this will change with SQLite 3.7's new Write Ahead Logging (WAL)
feature. Over in the Berkeley DB team we have put a btree that implements
transactional storage based on WAL under the SQLite parser/processor. This
technique can support a different locking model and lead to a very high
Thanks Greg I will check your version :)
Pablo
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Greg Burd
Sent: Friday, July 02, 2010 3:27 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multithreading
Hi,
Suppose that I have a number of files, each file has some numbers in
it (by line). I want to load the content of each file and the
associated filename into the following table.
create table test (id integer primary key, filename text, number integer);
For example, if file 'a' has number
On 2 Jul 2010, at 9:00pm, c...@comcast.net wrote:
I then created a sub-folder in my Eclipse Android project structure under the
assets folder and named it databases.
Is this the correct place to put a database file?
You can put your database file anywhere you have read/write privilages.
Try creating a script file something like(Psuedo code):
.separator ,
CREATE TEMP TABLE dummy (value);
.import file1.csv dummy
INSERT INTO TEST (filename,number) (SELECT 'file1.csv', value FROM dummy;
delete from dummy;
.import file2.csv dummy
INSERT INTO TEST (filename,number) (SELECT 'file2.csv',
Hi Simon,
Thanks very much for getting back to me.
You wrote -
Specify the full path of your file when you open the file. For example
/assets/databases/events.db.
That is my problem, I don't know how to do that.
Based on my current [limited] understanding of how Android opens a
On 3 Jul 2010, at 12:06am, c...@comcast.net wrote:
Snce the db is going to be created the 1st time thru the OnCreate() method
s/b called to create the only tbl.
public EventsData(Context ctx) {
super (ctx, DATABASE_NAME , null , DATABASE_VERSION );
}
What is the contents of
Hi,
create table test (value text default 'unknown', value2 text default 'unknown');
insert into test (value) values('xxx');
The above code works correctly. But if there is only one column with a
default value, I don't see how to insert a record with the default
value. I tried the following two
I tried the following two commands. Neither of them work. Would
you please let me know what is the command to insert a record with the
default value?
Try this:
insert into test default values;
Pavel
On Fri, Jul 2, 2010 at 9:40 PM, Peng Yu pengyu...@gmail.com wrote:
Hi,
create table test
On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov paiva...@gmail.com wrote:
I tried the following two commands. Neither of them work. Would
you please let me know what is the command to insert a record with the
default value?
Try this:
insert into test default values;
Peng, Now that Pavel has
On Fri, Jul 2, 2010 at 9:28 PM, Peng Yu pengyu...@gmail.com wrote:
On Fri, Jul 2, 2010 at 8:58 PM, P Kishor punk.k...@gmail.com wrote:
On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov paiva...@gmail.com wrote:
I tried the following two commands. Neither of them work. Would
you please let me know
Thank you
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
39 matches
Mail list logo