[sqlite] SQLite3 API

| Any plans for distribution of your cobol/sqlite interface ? The SQLite3 Interface for GnuCOBOL [sql3i4gc] will soon be available from the Contribution area of the GnuCOBOL Project. It is being released under the GNU GPLv3. The initial version con

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

On 11/23/2015 07:55, James K. Lowden wrote: > As a matter of fact, violation of UNIQUE & PK constraints is enforced > rather too strictly in SQLite. Any UPDATE statement that modifie more > than one row of a UNIQUE column can fail because two rows may > *transiently* have the same value. SQLite

[sqlite] SQLDIFF problem

You're probably right. You can try this shorter schema and get the same problem. create table xxx("" text); However, my point was that if SQLite3 allows it, SQLDIFF should be able to handle it also. Thanks. -Original Message- From: Tim Streater Sent: Monday, November 30, 2015 12:41 P

[sqlite] sqldiff ---primarykey bug

Hallo, I'm using the sqldiff tool with the --primarykey option to generate a diff between two databases with the "WITHOUT ROWID" optimization. sqldiff from sqlite 3.9.1 and 3.9.2 produces SQL statements with an incorrect WHERE clause. For example: UPDATE tt_dati SET codCommerciale='555' WHERE

[sqlite] SQLDIFF problem

On Mon, Nov 30, 2015 at 2:50 PM, Richard Hipp wrote: > https://www.sqlite.org/src/info/64263ccb8f9835c6 "tables with zero-length column names" Just curious. Why does SQLite allow those? Legacy (i.e. backward-compatibility)? Valid in ANSI SQL? --DD

[sqlite] sqldiff ---primarykey bug

On 11/30/15, Stuffer Oskar wrote: > Hallo, > > I'm using the sqldiff tool with the --primarykey option to generate a diff > between two databases > with the "WITHOUT ROWID" optimization. > sqldiff from sqlite 3.9.1 and 3.9.2 produces SQL statements with an > incorrect WHERE clause. > > > In the at

[sqlite] SQLDIFF problem

On 29 Nov 2015 at 18:55, tonyp at acm.org wrote: > Here?s a report about an SQLDIFF utility problem. > sqldiff: SQL statement error: near "IS": syntax error > > To reproduce, put the schema below (produced automatically by .IMPORT from a > CSV file so don?t bother with its appearance ? but it wor

[sqlite] SQLDIFF problem

On 11/30/15, Dominique Devienne wrote: > On Mon, Nov 30, 2015 at 2:50 PM, Richard Hipp wrote: > >> https://www.sqlite.org/src/info/64263ccb8f9835c6 > > > "tables with zero-length column names" > > Just curious. Why does SQLite allow those? Legacy (i.e. > backward-compatibility)? Valid in ANSI SQL

[sqlite] SQLDIFF problem

https://www.sqlite.org/src/info/64263ccb8f9835c6 -- D. Richard Hipp drh at sqlite.org

[sqlite] security problem in ASP.NET C# library

Hello After migration from Windows Server 2003 to Windows Server 2012R2 the following error occurs in the C# library (version 1.0.098.1): "That assembly does not allow partially trusted" The server is shared and there is no possibility to change system settings. The program uses ASP.NET C# lib