e Database'
Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)
Zachary Yates wrote:
>
> create view ProgrammingMapView as
> select
> p.Id ProductId
> , pt.Id ProtocolId
> , m.Id Mid
> from Mid m
> join MidProdu
Here is the DDL for the scenario:
create table Country (
Id integer primary key,
Code text,
Title text,
ShortTitle text,
ModifiedOn text,
ModifiedBy integer
);
create table Mid (
Id integer primary key,
CountryCode text,
se
Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)
On 28 Aug 2014, at 12:47am, Zachary Yates wrote:
> That's not actually the issue. When I run the query using the SQLite console
> or via another driver, (for example using 0xDBE + Xerial), the column names
&
e: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)
On 27 Aug 2014, at 8:30pm, Zachary Yates wrote:
> When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method
> returns only the table name, in my case "Country".
You do not provide your own names
uot; ASC
When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method
returns only the table name, in my case "Country".
There's a lot more detail to this question posted at:
http://stackoverflow.com/questions/25534898/trouble-with-sqlexpressiont-join-and-column-names
Thanks in advance for any help,
Zachary Yates
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
5 matches
Mail list logo
