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 anywa
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:
Keith,
Ahh, better to
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 wrote:
> -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
>
> Is this a right mail group for Sy
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 w
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".
Or "FROM a INNER JOIN
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 case_
7 matches
Mail list logo