Hi, I am using C API I am using sqlite3_column_type to determine, the type of column as it is requirement for me to decide whether to return the value as string or number. It works well, but not in case when i use left outer join.
When i use left outer join, the column type returned is always NULL irrespective of the actual column type, for the all other tables in joint source than first one (IE for first one it returns correct column type) For example SELECT a.col1, a.col2, b.col3, b.col4 FROM table1 a LEFT OUTER JOIN table2 b ON a.col1=1; Then for table which has alias b, is the table for which i get get all column type NULL.. -- Namaskar, Sumedh S Bhogle Mumbai | Mob. 09969085122 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users