Hi,
The issue I found about indexes on another column than the primary key is
now corrected, I obtain the desired results. Thank you for your efficiency
and your quickness.
Eric DAVID
-Message d'origine-
De : sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] De
juillet 2014 10:49
À : sqlite-users@sqlite.org
Objet : Re: [sqlite] System.Data.Sqlite
Eric DAVID wrote:
> Well, It seems to be impossible to join files to mails. So, here are
> the statements :
>
> CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT
> NULL, lig_no
...@sqlite.org] De la part de Eric DAVID
Envoyé : mardi 29 juillet 2014 01:40
À : 'General Discussion of SQLite Database'
Objet : Re: [sqlite] System.Data.Sqlite
Here is the list of all sql statements in the file Base.sql, included INSERT
Statements.
I think the issue comes from the index idx_Pylones_lig_id
Here is the list of all sql statements in the file Base.sql, included INSERT
Statements.
I think the issue comes from the index idx_Pylones_lig_id.
Eric DAVID
-Message d'origine-
De : sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] De la part de Joe Mistachkin
À : 'General Discussion of SQLite Database'
Objet : Re: [sqlite] System.Data.Sqlite
Eric DAVID wrote:
>
> SELECT * FROM Pylones P
> JOIN Lignes L ON L.lig_id = P.lig_id
> JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3;
>
Is the above query the one that has t
with System.Data.Sqlite 3.8.5 when it
exists an index on another column than the primary key.
Regards.
Eric DAVID
-
CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
lig_nom TEXT NOT NULL);
SELECT AddGeometryColumn('Lignes', 'lig_geom', 2154, 'LINESTRING', 'XY');
SELECT CreateSpatialIndex
ailto:sqlite-users-boun...@sqlite.org] De la part de Simon Slavin
Envoyé : lundi 28 juillet 2014 15:43
À : General Discussion of SQLite Database
Objet : Re: [sqlite] System.Data.Sqlite
On 28 Jul 2014, at 1:01pm, Eric DAVID <ericdav...@orange.fr> wrote:
> I have a problem using Syst
.5)
So, I would like to know if there is a bug in System.Data.SQLite or if I
don't understand something using this assembly.
Eric DAVID
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
8 matches
Mail list logo