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
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
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
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
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
>)
>
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 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
On Fri, Jul 2, 2010 at 11:19 AM, P Kishor wrote:
> On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu 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.
On Fri, Jul 2, 2010 at 11:19 AM, P Kishor wrote:
> On Fri, Jul 2, 2010 at 11:19 AM, P Kishor wrote:
>> On Fri, Jul 2, 2010 at 11:15 AM, Peng Yu wrote:
>>> Hi,
>>>
>>> SELECT DISTINCT type_id FROM foods;
>>>
>>> If I use 'distinct',
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?
SELECT, min(Count(type_id),n)
FROM foods
GROUP BY
___
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
On Fri, Jul 2, 2010 at 11:35 AM, Black, Michael (IS)
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
> Ä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
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
P Kishor 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
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 wrote:
> P Kishor 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
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 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
Igor Tandetnik wrote:
> P Kishor 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
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
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
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
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
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
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 wrote:
> Hi,
>
> create
On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov 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
On Fri, Jul 2, 2010 at 9:28 PM, Peng Yu wrote:
> On Fri, Jul 2, 2010 at 8:58 PM, P Kishor wrote:
>> On Fri, Jul 2, 2010 at 8:52 PM, Pavel Ivanov wrote:
I tried the following two commands. Neither of them work. Would
you
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