Re: [sqlite] bug "PRAGMA table_info"

Thank you! On 06/19/2012 08:25 PM, Jay A. Kreibich wrote: > On Tue, Jun 19, 2012 at 08:16:37PM +0200, Patrik Nilsson scratched on the > wall: >> Hi All, >> >> I use "PRAGMA table_info" to check my tables at start up and if the >> table columns are the need of updating (adding or removal) I do

Re: [sqlite] bug "PRAGMA table_info"

On Tue, Jun 19, 2012 at 08:16:37PM +0200, Patrik Nilsson scratched on the wall: > Hi All, > > I use "PRAGMA table_info" to check my tables at start up and if the > table columns are the need of updating (adding or removal) I do that. > > After a redesign of how the databases are managed this

[sqlite] bug "PRAGMA table_info"

Hi All, I use "PRAGMA table_info" to check my tables at start up and if the table columns are the need of updating (adding or removal) I do that. After a redesign of how the databases are managed this doesn't work anymore. Instead of using several database connections, I use one. The cleaned up

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

Also I've just noticed the title of this thread says that you use SQLite 2.8.6. Are you sure you are using SQLite that ancient both in your app and in SQLShell? And that's on a super-modern OS Windows 8? On Tue, Jun 19, 2012 at 12:37 PM, Black, Michael (IS) wrote: >

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

Or..the string being displayed in your app isn't being reset to empty when there are no records. Since you didn't mention what happens when you delete just some of the records instead of all. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

I thinki you need a sanity check. Either your own or somebody looking over your shoulder. If you reboot the OS and it sill has records when you think (and see) 0 records then, in all high-probability likelihood, you are doing something wrong. The idea that you can add records and they show

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

Then it's definitely different database files or indeed some really weird network disk caching. Pavel On Tue, Jun 19, 2012 at 12:19 PM, wrote: > Good question. I thought the same, the issue persists across  not just an app > restart but a restart of the entire OS. >

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

It seems to me you are using SQLite database in WAL-mode and when you delete rows from SQLShell your app has some read-only transaction open (or it has already started executing its SELECT statement that should return deleted rows). Does the issue persist across app restarts? Pavel On Tue, Jun

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

Your database isn't on a network share, is it? Sounds like data caching is ocurring. Does your app close and re-open the database? What kind of "app" are you running? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Tuesday, June 19, 2012 11:27 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries > 4.      Try to select

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

> 4.      Try to select against any of these tables and 0 results are returned > yet, the client db hasn't actually changed it's size. By default SQLite doesn't shrink database file size when deleting data, although it reuses this space later when you insert new data. If you want to shrink file

Re: [sqlite] last_insert_rowid() with conflict

On Tue, Jun 19, 2012 at 11:02 AM, Baruch Burstein wrote: > If I have a column that has unique values, and the ON CONFLICT clause is > IGNORE, is there a way to get the rowid of the last insert (on > success) *or*the last conflict (on conflict). I would like to just > keep

[sqlite] last_insert_rowid() with conflict

If I have a column that has unique values, and the ON CONFLICT clause is IGNORE, is there a way to get the rowid of the last insert (on success) *or*the last conflict (on conflict). I would like to just keep adding to the table without worrying if there is a duplicate, but after each insert I need

Re: [sqlite] Bug: incorrect forward declaration ofsqlite3_win32_sleep

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/06/12 22:55, Joe Mistachkin wrote: > The new function is unsupported; however, it is required from places > in the testing infrastructure where the sqlite3_sleep function cannot > be called for one reason or another (e.g. there is no VFS yet).

Re: [sqlite] escaping GLOB pattern

nobre wrote: > "If the optional ESCAPE clause is present, then the expression following the > ESCAPE keyword must evaluate to a string consisting of a single character. > This character may be used in the LIKE pattern to include literal percent or > underscore characters. The escape character

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

Arbol One wrote: > Since the purpose of this exercise is to create a simple table, could you > tell me if this is all I have to do? Are there any > other steps? Well, did it work? You can examine the database file using sqlite3 command line shell, or any of the

Re: [sqlite] Building an fts Query for Double Quote

With the default tokenizer your index would split such an input (quot'ed) into 'quot' and 'ed' , you wouldn't get a hit for a phrase such as "quot''ed". If you use a custom tokenizer , you CAN use " in your terms/queries, however it won't work for phrases, only for single tokens >From the

Re: [sqlite] escaping GLOB pattern

"If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must evaluate to a string consisting of a single character. This character may be used in the LIKE pattern to include literal percent or underscore characters. The escape character followed by a percent

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

Hi Igor. Since the purpose of this exercise is to create a simple table, could you tell me if this is all I have to do? Are there any other steps? - Original Message - From: Igor Tandetnik Sent: 06/18/12 08:36 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - int

Re: [sqlite] substr bug in 3.7.13?

Oh, sorry. It was my fault. It works very well with starting number 1. :) 2012/6/19 Bart Smissaert > Should that zero not be a 1? > From the documentation: > The left-most character of X is number 1 > > RBS > > > On 6/19/12, Yongil Jang wrote: >

Re: [sqlite] substr bug in 3.7.13?

Should that zero not be a 1? >From the documentation: The left-most character of X is number 1 RBS On 6/19/12, Yongil Jang wrote: > Dear all, > > I've found following result when I try to use 'substr' function. > > sqlite> create table test (data text); > sqlite> insert

[sqlite] substr bug in 3.7.13?

Dear all, I've found following result when I try to use 'substr' function. sqlite> create table test (data text); sqlite> insert into test values ('010101'); sqlite> select substr(data, 0, 2) from test; 0 sqlite> select substr(data, 0, 3) from test; 01 As you can see, string length should be

Re: [sqlite] Odd insertion error FTS4 + ICU

On 06/19/2012 04:28 AM, E. Timothy Uy wrote: > Dear Dan, > > With the change from U8_NEXT to U16_NEXT, I am able to insert 一日耶羅波安出. I > was also able to insert the rest of the data set (about 31000 more rows > containing both traditional and simplified Chinese). Is this an ICU error? > Seems like