[sqlite] application for initial charge

2016-04-09 Thread Jean-Christophe Deschamps
At 07:14 09/04/2016, you wrote: >I have implemented an application with Lazarus+FPCompiler, using SQLite >tables, and the information was obtained from Excel tables previously >done. > >I hope it would be very simple to prepare in the former Excel tables a >sheet >with the information required

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

2016-04-09 Thread Mike Bayer
On 04/06/2016 10:33 AM, Richard Hipp wrote: > On 4/4/16, Mike Bayer wrote: >> The "type" column in PRAGMA table_info() is now a blank string when the >> target object is a view in 3.12.0. In 3.11.0 and prior versions, the >> typing information is returned, >> > > I think the problem is fixed by

[sqlite] sqlite error 25 during bind

2016-04-09 Thread Kumar Suraj
Yes i am calling sqlite3_prepare_v2 snprintf(command, 512, INSERT_DN); if ( (rv = sqlite3_prepare_v2(sqlHandle->db, command, -1, , NULL) ) != SQLITE_OK ) { fprintf(stderr, "Error Insert : sqlite3_prepare_v2, Error code : %d\n",

[sqlite] application for initial charge

2016-04-09 Thread hfiandor
Thanks very much to Jean-Christophe Deschamps Regards Ing. H?ctor F. Fiandor Rosario

[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Richard Hipp
On 4/9/16, Richard Hipp wrote: > On 4/9/16, Bradley Grainger wrote: >> In some circumstances "DELETE FROM x WHERE col = val" may fail to delete >> all >> rows if "PRAGMA reverse_unordered_selects = true;" has been executed. >> > > https://sqlite.org/src/info/a306e56ff68b8fa5 Should be fixed now

[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Bradley Grainger
In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all rows?if?"PRAGMA reverse_unordered_selects = true;" has been executed. Steps to repro: Open the test DB (https://downloads.logoscdn.com/temp/test.db 40KB)?with SQLite 3.12.1 Run: pragma reverse_unordered_selects =

[sqlite] application for initial charge

2016-04-09 Thread Simon Slavin
On 9 Apr 2016, at 6:14am, hfiandor wrote: > I hope it would be very simple to prepare in the former Excel tables a sheet > with the information required by my application and ?charge it? instead of > the manual introduction as now. Take a copy of your Excel spreadsheet. Add a new column

[sqlite] Broken database after experiments with fts.

2016-04-09 Thread Cezary H. Noweta
Hello, On 2016-03-29 19:25, Dan Kennedy wrote: >http://sqlite.org/src/info/d0a3853b37230c12 > The fix should appear as part of the 3.13 release (not 3.12 - the > version that was tagged earlier this morning). Could that check--in be incorporated into next minor version? It fixes rather

[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Richard Hipp
On 4/9/16, Bradley Grainger wrote: > In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all > rows if "PRAGMA reverse_unordered_selects = true;" has been executed. > https://sqlite.org/src/info/a306e56ff68b8fa5 -- D. Richard Hipp drh at sqlite.org

[sqlite] Expecting syntax error on delete

2016-04-09 Thread Richard Williams
I have a PHP program where I have the equivalent of the following code. The code was not deleting the expected rows ('abc' & 'def') because of the bad syntax. However the error did not throw an exception. Is this what I should expect? $p = new PDO('sqlite::memory:');

[sqlite] SQLite 3.8.11 Crashed with Mutlithread

2016-04-09 Thread 蔡畅(雁闲)
Hi ?? ?

[sqlite] application for initial charge

2016-04-09 Thread hfiandor
Dear list members: Recently I have worked with an application for initial charge of an Accounting System. It was very simple and I suspect that was implemented with EXCEL and the Accounting System BD motor is not an SQLite (maybe FoxPro). The main idea is to prepare an accounting entry (I