jeudi 29 janvier 2015

android - how to get to the column name or column count in result set of query in sqlite?

case1) sql : select a.a, a.b, b.c from a, b where a.a=b.a; case2) sql : select '' from table; case3) sql : select '' from table1, table2 where table1.a=table2.a; case4) sql : select '*' from table1 left join table2 on table1.a=table2.a; case1 is knew the column name in result set of sql (OK) case2 is possible find column name (use to pragma table_info (table);) (OK) but case3,case4 is how to get to the column name of column count in result set?


Aucun commentaire:

Enregistrer un commentaire