Re: [sqlite] Foreign key error...

2017-01-09 Thread Ken Wagner
Yes, thanks. The 'left join on' or 'inner join on ' removes the chance of an erroneous key linkage. Also makes sense to pay close attention as to which table is left and right. Ken On 01/09/2017 06:46 AM, Dominique Devienne wrote: On Sun, Jan 8, 2017 at 12:46 PM, Keith Medcalf

Re: [sqlite] Need help with System.Data.SQLite

2017-01-09 Thread GB
System.Data.SqlTypes.SqlDecimal is specific to the SQL Server provider and thus the SQLite provider doesn't know how to handle it. Try using System.Decimal as a more generic approach. If you need to be portable across providers, you will be better off using classes from System.Data.Common

Re: [sqlite] Foreign key error...

2017-01-09 Thread Ken Wagner
Keith, "this does not allow the same track on multiple albums" with the same trackno, but a different trackno seems to work. Thus results cannot be guaranteed valid? Ken On 01/08/2017 06:57 AM, Keith Medcalf wrote: On Sunday, 8 January, 2017 05:05, Ken Wagner wrote:

[sqlite] Need help with System.Data.SQLite

2017-01-09 Thread Burtsev , Dmitriy
Is this a right mail group for System.Data.SQLite ? -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Burtsev, Dmitriy Sent: Thursday, January 05, 2017 9:08 AM To: 'sqlite-users@mailinglists.sqlite.org' Subject: [sqlite] Need help

Re: [sqlite] Need help with System.Data.SQLite

2017-01-09 Thread Drago, William @ CSG - NARDA-MITEQ
> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Burtsev, Dmitriy > Sent: Monday, January 09, 2017 10:10 AM > To: 'SQLite mailing list' > Subject: [sqlite] Need help with System.Data.SQLite

Re: [sqlite] Foreign key error...

2017-01-09 Thread Dominique Devienne
On Sun, Jan 8, 2017 at 12:46 PM, Keith Medcalf wrote: > > ... join ... using (column) has nothing whatever to do with foreign keys. > > "FROM a JOIN b USING (c) is "syntactic sugar" ([...]) for the expression > "FROM a, b WHERE a.c = b.c" > Or "FROM a JOIN b ON a.c = b.c".

Re: [sqlite] LIKE and the like and SIMilarity

2017-01-09 Thread Clemens Ladisch
Anony Mous wrote: > In SqLite, LIKE works backwards. It's not case-sensitive, although it > should be. The SQL standard specifies that LIKE does comparisons using the collation of the string values. SQLite uses NOCASE by default. You could override the like() function (which is what PRAGMA