B4J Question SQLite Select Multiple Tables Columntitle Tableview

[rwblinn]

Hi,

has someone a hint how to get the tablename.columnname when selecting from multiple tables and show these in the TableView columnheadings?

SELECT * FROM TABLE1, TABLE2

 

[Erel]

You can use ResultSet.GetColumnName (together with ColumnCount).

 

[rwblinn]

Hi Erel,

I know, but it does not show which table the column belongs to. With that, it would not be possible to determine what kind of field is being displayed, to take special action (like for a BLOB field).
Tried sql statements like SELECT T1.Col1, T2.Col2 FROM T1 as t1, T2 as t2 but getcolumnname only shows the fieldname.

I have build a short demo app to illustrate - see attached.

 

[Erel]

Try this:

SELECT T1.Col1 AS c1, T2.Col2 As c2 FROM t1, t2

GetColumnName will return c1 and c2. Does it solve the problem?