I am confused about the difference of handling table and view selects by
sqlite.. I have the following view query:
SELECT
TLP.name, TLP.jar_file, TLP.log_file, ...
FROM
tasks_list_page TLP
and a table query:
SELECT
TSK.name, TSK.jar_file, TSK.log_file, ...
FROM
task TSK
When I obtain the column name through sqlite3_column_name() I get
different results for query on view (ALIAS.COLUMN) than for query on
table (COLUMN). The alias is included in column name for view query but
not in table query, even though it is explicitely specified.
Where does the difference come from? How are view selects handled
differently than table selects? Is this intentional? If so, then what is
the reasoning behind it?
Pozdrawiam,
Dariusz Wawer
--
+------------------- http://www.cc.com.pl/ --------------- +
CCCC CCCC CC Otwarte Systemy Komputerowe Sp. z o.o. --------- |
CCC CCC - CheckPoint, Juniper, SafeNet, Vasco Partner |
CC CC - Internet, Intranet, WWW, Bezpieczne sieci |
CCC CCC - TEL,FAX (+48) 22 646-68-73, 606-37-80 - |
CCCC CCCC - Rakowiecka 36, Warszawa, 02-532 PL -- |
+------------------------------------------------------------------+
Spółka zarejestrowana w Wydz.XIII Gospodarczym Krajowego Rejestru |
Sądowego, nr KRS 0000023570, zarząd: Grzegorz Blinowski - Prezes |
Zarządu, Tomasz Ramsza - Członek Zarządu; Kapitał zakł.:100000 PLN |
+----------------------------------------------------------------- +
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
