Re: [sqlite] how to write "\n\r" each line in the output txt file?

On Wed, May 16, 2012 at 9:30 PM, YAN HONG YE wrote: > > > >when I use : > > > >.output akk.txt > >select * from dhq where qph>0; > >.output stdout > > > > command to write a txt file,I found no "\n\r" in the each line, > > when I use ultraedit to open the txt file, I found

Re: [sqlite] sqlite max query parameters differs on Snow Leopard?

> sqlite has a hard limit on the number of query parameters, of 999. This > is set in headers which are not part of the public header file, and the > runtime gives you the ability to lower the limit, but not exceed the > hard limit. The maximum value in the Python sqlite3 module on Snow > Leopard

[sqlite] how to write "\n\r" each line in the output txt file?

>when I use : > >.output akk.txt >select * from dhq where qph>0; >.output stdout > > command to write a txt file,I found no "\n\r" in the each line, when I use ultraedit to open the txt file, I found end of each line is 0x0D, How to write "0x0D 0x0A" each line? may be should change the

Re: [sqlite] How do you access a specific row of a resultset?

On 16 May 2012, at 11:14pm, Goatjugsoup wrote: > Well, a new thought just came to me, if I use the same sql statement will the > resultset be in the same order each time because if that is the case I > imagine I could use a for statement and an index to move through it

Re: [sqlite] How do you access a specific row of a resultset?

> if I use the same sql statement will the > resultset be in the same order each time Only if you use ORDER BY clause, and the set of columns in this clause have unique values for each row, and all these values don't change between query executions. Pavel On Wed, May 16, 2012 at 6:14 PM,

Re: [sqlite] How do you access a specific row of a resultset?

Well, a new thought just came to me, if I use the same sql statement will the resultset be in the same order each time because if that is the case I imagine I could use a for statement and an index to move through it the way I want to with next inside of that as many times as it takes to get to

Re: [sqlite] Please review this email to sqlite's mailing list

On Wednesday, May 16, 2012 1:28:17 e.h. Simon Slavin wrote: > On Tue, May 15, 2012 at 1:55 PM, Charles Samuels wrote: > > At some point, we get a checkpoint; at this instant, what is in otherdb > > and what is in sqlite is what we want committed to sqlite, if either of > >

Re: [sqlite] Please review this email to sqlite's mailing list

On Tue, May 15, 2012 at 1:55 PM, Charles Samuels wrote: > At some point, we get a checkpoint; at this instant, what is in otherdb and > what is in sqlite is what we want committed to sqlite, if either of them > fails, we can rollback both of them and both databases return to

Re: [sqlite] Please review this email to sqlite's mailing list

On Wednesday, May 16, 2012 11:33:02 f.h. Igor Tandetnik wrote: > Well, SQLite doesn't. Basically, you want SQLite to maintain multiple > not-yet-committed versions of the same record. Well, yes, but it already does; you can rollback a savepoint. If I could rollback a savepoint and then

Re: [sqlite] Please review this email to sqlite's mailing list

On 5/15/2012 1:55 PM, Charles Samuels wrote: The question here is: where can I put that "more data" so that it won't be part of checkpoint 1, but is still accessable by sqlite select statements? (Accept that otherdb allows asychronous commits such that I can add more data to it that doesn't wind

Re: [sqlite] Query by License -Consulta por Licencia

Guillermo: Due to generous copyright conditions of its author DRH, you can use SQLite in any application you want and for any purpose. HTH -- -- Adolfo J. Millan Zator Systems. > > Mensaje original > De: Guillermo Soland > Para: sqlite-users@sqlite.org >

Re: [sqlite] Please review this email to sqlite's mailing list

On Wednesday, May 16, 2012 10:00:37 f.h. Adam DeVita wrote: > Did you check out > http://www.sqlite.org/inmemorydb.html > > Could you use an in-memory db to act as a db for a save point? Yes, but this is incredibly hard: I have to maintain the schema twice, I can't allow the user to enter their

Re: [sqlite] How do you access a specific row of a resultset?

The other thing you are not thinking about is that you never know the order of data in a set. You may think that you want the 5th record that was ever inserted into the table, but you have no guarantee that a select statement will return records in the order in which they were inserted. The

Re: [sqlite] Please review this email to sqlite's mailing list

Did you check out http://www.sqlite.org/inmemorydb.html Could you use an in-memory db to act as a db for a save point? When you are ready to commit, do so from 1 in memory db, while accumulating into another in preparation for that save point. Adam On Tue, May 15, 2012 at 1:55 PM, Charles

Re: [sqlite] How do you access a specific row of a resultset?

Goatjugsoup wrote: > Hi, I want to know how to go about getting a specific row from a resultset > (or if there is a different way to do it Im all for that too) That rather depends on what "it" is. What's the point of the exercise? Are you looking to implement something

Re: [sqlite] import problem

Donald Griggs ha scritto quanto segue il 16/05/2012 13.24> Hello, Spora, Regarding: *I have problem when import with versione superior to 3071000. No problem with 3071000.* ..\sqlite3 -echo aa_VUOTO.db 0 1744: i have the last line as the previous. I tryed with and without the carriage

Re: [sqlite] NULL sqlite3_stmt in function calls

On Wed, May 16, 2012 at 7:16 AM, Baruch Burstein wrote: > Are all API functions that accept an sqlite3_stmt* safe (=NO-OPs) to call > with a NULL pointer? I mean things like bind, column, etc. > No. sqlite3_finalize() is, but most others are not. > > -- > ˙uʍop-ǝpısdn sı

Re: [sqlite] Query by License -Consulta por Licencia

2012/5/16 Guillermo Soland : > Mr. Representative of SQLite: > > > Hello, my name is Guillermo G. Soland, I live in the city of Villa > Constitución, Santa Fe, Argentina, I graduated as a Computer Systems Analyst, > but now I do not practice my profession for profit because my

Re: [sqlite] Escape table and column names

At 13:55 16/05/2012, you wrote: ´¯¯¯ Those all work. You are getting an error because you didn't supply any column in the table `--- Oops, that's what happens when you try doing too many things at the same time. Nonetheless, SQLite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for

Re: [sqlite] Accented chars in Android embeded Sqlite.

On Tue, May 15, 2012 at 9:23 PM, Yahoo wrote: > Hi everyone! > > I’m Brazilian, also, Android Dev. > > I’m in a struggle with Sqlite and accented chars such as ‘á’ or ‘é’. > > What I’m trying to do is a select with where accent insensitive. > > For months I have having

Re: [sqlite] sqlite max query parameters differs on Snow Leopard?

On Tue, May 15, 2012 at 4:27 PM, Samuel Bayer wrote: > All - > > I posted this query on stackoverflow, but I'm probably more likely to get > an answer here. > > http://stackoverflow.com/**questions/10332668/sqlite-max-** >

[sqlite] import problem

I have problem when import with versione superior to 3071000. No problem with 3071000. ..\sqlite3 -echo aa_VUOTO.db 0http://www.email.it/f Sponsor: Fino al 2 Giugno una settimana Euro 310 nel Family Hotel King di Milano Marittima. Speciale settimana corta con arrivo la domenica e partenza al

[sqlite] Accented chars in Android embeded Sqlite.

Hi everyone! I’m Brazilian, also, Android Dev. I’m in a struggle with Sqlite and accented chars such as ‘á’ or ‘é’. What I’m trying to do is a select with where accent insensitive. For months I have having research over and over the internet to accomplish that, but, unfortunately unsuccessful.

[sqlite] Query by License -Consulta por Licencia

Mr. Representative of SQLite: Hello, my name is Guillermo G. Soland, I live in the city of Villa Constitución, Santa Fe, Argentina, I graduated as a Computer Systems Analyst, but now I do not practice my profession for profit because my job is totally alien to what I studied , he wanted to see

[sqlite] sqlite max query parameters differs on Snow Leopard?

All - I posted this query on stackoverflow, but I'm probably more likely to get an answer here. http://stackoverflow.com/questions/10332668/sqlite-max-query-parameters-differs-on-snow-leopard An overgeneralization in some code I'm writing revealed some differing behavior between the Python

Re: [sqlite] Escape table and column names

On Wed, May 16, 2012 at 01:47:01PM +0200, Jean-Christophe Deschamps scratched on the wall: > > >> This FAQ topic doesn't apply here. We're talking about schema > >names or keywords, while FAQ#14 is literal escaping a single > >quote. > > > >create table "foo""bar" ( baz ); > > > >select * from

Re: [sqlite] Escape table and column names

On Wed, May 16, 2012 at 2:47 PM, Jean-Christophe Deschamps wrote: > > > This FAQ topic doesn't apply here. We're talking about schema names or >> keywords, while FAQ#14 is literal escaping a single quote. >> >> create table "foo""bar" ( baz ); >> >> select * from

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

On 05/16/2012 06:04 PM, Stephan Beal wrote: On Wed, May 16, 2012 at 1:02 PM, Dan Kennedy wrote: Not so. It's the number of columns of data currently available. Which is sometimes the same as sqlite3_column_count() and sometimes zero. Can sqlite3_data_count() be used

Re: [sqlite] Escape table and column names

> This FAQ topic doesn't apply here. We're talking about schema names or keywords, while FAQ#14 is literal escaping a single quote. create table "foo""bar" ( baz ); select * from "one""two"; select * from sqlite_master; table|foo"bar|foo"bar|9|CREATE TABLE "foo""bar" ( baz ) I knew this

Re: [sqlite] Escape table and column names

On May 16, 2012, at 1:15 PM, Jean-Christophe Deschamps wrote: > This FAQ topic doesn't apply here. We're talking about schema names or > keywords, while FAQ#14 is literal escaping a single quote. create table "foo""bar" ( baz ); select * from "one""two"; select * from sqlite_master;

Re: [sqlite] Escape table and column names

On Wed, May 16, 2012 at 2:25 PM, Simon Slavin wrote: > > On 16 May 2012, at 11:56am, Petite Abeille > wrote: > > > On May 16, 2012, at 12:28 PM, > wrote: > > > >> Anyone have an answer? > > > >

Re: [sqlite] Escape table and column names

On 16 May 2012, at 11:56am, Petite Abeille wrote: > On May 16, 2012, at 12:28 PM, wrote: > >> Anyone have an answer? > > http://www.sqlite.org/lang_keywords.html > >> What about if table name or column name contains that escape

[sqlite] NULL sqlite3_stmt in function calls

Are all API functions that accept an sqlite3_stmt* safe (=NO-OPs) to call with a NULL pointer? I mean things like bind, column, etc. -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Escape table and column names

> What about if table name or column name contains that escape character? > Do I need to escape it in another way? http://sqlite.org/faq.html#q14 This FAQ topic doesn't apply here. We're talking about schema names or keywords, while FAQ#14 is literal escaping a single quote. Given that

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

On 05/16/2012 05:57 PM, Petite Abeille wrote: On May 16, 2012, at 12:49 PM, Baruch Burstein wrote: sqlite3_column_count Number of columns. http://www.sqlite.org/c3ref/column_count.html sqlite3_data_count Number of rows. http://www.sqlite.org/c3ref/data_count.html Not so. It's the

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

On 05/16/2012 05:49 PM, Baruch Burstein wrote: sqlite3_column_count sqlite3_data_count What is the difference between the two? sqlite3_data_count() will return zero if the statement handle does not currently point to a row of data. For example if it has just been prepared or reset, or if the

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

On May 16, 2012, at 12:49 PM, Baruch Burstein wrote: > sqlite3_column_count Number of columns. http://www.sqlite.org/c3ref/column_count.html > sqlite3_data_count Number of rows. http://www.sqlite.org/c3ref/data_count.html ___ sqlite-users

Re: [sqlite] Escape table and column names

On May 16, 2012, at 12:28 PM, wrote: > Anyone have an answer? http://www.sqlite.org/lang_keywords.html > What about if table name or column name contains that escape character? > Do I need to escape it in another way? http://sqlite.org/faq.html#q14

[sqlite] sqlite3_column_count vs. sqlite3_data_count

sqlite3_column_count sqlite3_data_count What is the difference between the two? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Escape table and column names

Hello, I would like to receive a definitive answer about what is the recommended way to escape table and column names. SQLite supports single quotes, double quotes and square brackets (for mySQL compatibility) … but I haven't yet found the official or recommended way. Anyone have an answer? What

[sqlite] import problem

I have problem when import with versione superior to 3071000. No problem with 3071000. ..\sqlite3 -echo aa_VUOTO.db 0http://www.email.it/f Sponsor: Offerta Hotel + parchi con l'hotel Europa di Misano Adriatico, vendita biglietti in prevendita per un soggiorno tutto compreso in un hotel per

Re: [sqlite] How do you access a specific row of a resultset?

On 16 May 2012, at 9:04am, Goatjugsoup wrote: > Hi, I want to know how to go about getting a specific row from a resultset > (or if there is a different way to do it Im all for that too) > > My code goes something like this, stat being a statement variable already >

[sqlite] How do you access a specific row of a resultset?

Hi, I want to know how to go about getting a specific row from a resultset (or if there is a different way to do it Im all for that too) My code goes something like this, stat being a statement variable already initialised previously. I thought perhaps absolute sounds like it might give the