Hello David, When I'am specifically asking for the same named field "nom" on two different table "auteurs" and "proprietaires" as "select distinct proprietaires.nom, auteurs.nom from auteurs, proprietaires;" then the result is the same name for both:
2015-11-02 21:26:28.11 : nom => P1 2015-11-02 21:26:28.11 : nom => A1 2015-11-02 21:26:28.11 : nom => P21 2015-11-02 21:26:28.11 : nom => A1 2015-11-02 21:26:28.11 : nom => P3 2015-11-02 21:26:28.11 : nom => A1 Same as in the CLI: sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs, proprietaires; nom|nom P1|A1 P21|A1 P3|A1 There is 2 pragmas but they are written deprecated (I don't find why). http://www.sqlite.org/pragma.html#pragma_full_column_names http://www.sqlite.org/pragma.html#pragma_short_column_names They do almost the job: sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs, proprietaires; proprietaires.nom|auteurs.nom P1|A1 P21|A1 P3|A1 sqlite> select auteurs.* from auteurs; auteurs.ns|auteurs.nom|auteurs.prenom|auteurs.biographie|auteurs.commentaire 1|A1||null|null But also with simple named field as I don't expect it: sqlite> select nom from auteurs; auteurs.nom A1 Anyway thanks, Pascal. http://blady.pagesperso-orange.fr > Le 1 nov. 2015 à 01:22, Rabbi David Botton <da...@botton.com> a écrit : > > Try something like this to see how the database engine is returning the > results: > > while RS.Next loop > for J in 1 .. RS.Number_Of_Fields loop > V.Put_Line (RS.Field_Name (J) & " => " & > RS.Field_Value (J)); > end loop; > end loop; > > David Botton > ------------------------------------------------------------------------------ _______________________________________________ Gnoga-list mailing list Gnoga-list@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gnoga-list
