How to retreive (for a column): original field name and base table name from a sqlite3_stmt*

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

How to retreive (for a column): original field name and base table name from a sqlite3_stmt*

rlodina
Hi,

1. Retrieve original field name:

 CREATE TABLE A (ID int, Name );
SELECT ID AS MyID, Name As MyName FROM A

sqlite3_column_name - return the alias MyID - It's a way to obtain the real
name of column (ID) based on sqlite3_stmt* pointer ?

2. Retrieve base table name:

 CREATE TABLE B (ID int );
SELECT B.ID <http://B.ID> AS MyID, A.Name As MyName FROM A LEFT OUTER JOIN B
ON A.ID <http://A.ID> = B.ID <http://B.ID>

It's there a way to obtain the base table name for MyID field (B).


For both case I only have sqlite3_stmt* pointer ( parse sqlStatement string
it's not a acceptable solution).

Thank you.


Regards
Radu Lodina