Re: [sqlite] Escaping binary data

Thank you ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to supply no values when inserting a record?

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

Re: [sqlite] How to supply no values when inserting a record?

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

Re: [sqlite] How to supply no values when inserting a record?

> 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

[sqlite] How to supply no values when inserting a record?

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

Re: [sqlite] working with existing (look-up) database in Android/Eclipse

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

Re: [sqlite] working with existing (look-up) database in Android/Eclipse

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

Re: [sqlite] loading data from file with the file name as the extra field

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

Re: [sqlite] working with existing (look-up) database in Android/Eclipse

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

[sqlite] loading data from file with the file name as the extra field

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

Re: [sqlite] Multithreading support approach

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

Re: [sqlite] Multithreading support approach

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

Another +1 on the "awestruck"! Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

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

Re: [sqlite] Multithreading support approach

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

Re: [sqlite] How to select an entry that appears l t;=n times and only show n times if it appears mor e than n times?

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears<=ntimes and only show n times if it appears more than n times?

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

Re: [sqlite] How to select an entry that appears =n times and only show n times if it appears more th an n times?

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

[sqlite] Multithreading support approach

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=ntimes and only show n times if it appears more than n times?

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

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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.

Re: [sqlite] problem with auto boot

> Ä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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

> 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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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',

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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.

Re: [sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

[sqlite] How to select an entry that appears <=n times and only show n times if it appears more than n times?

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

Re: [sqlite] UPDATE without a JOIN

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 >) >

Re: [sqlite] problem with auto boot

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

Re: [sqlite] EXTERNAL: Bug with commandline option -csv and -separator

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

Re: [sqlite] EXTERNAL:Re: problem with auto boot

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

Re: [sqlite] problem with auto boot

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

Re: [sqlite] Proposed new sqlite3_open_v3() interface - offt

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