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