Thanks for all the answers. The solution to check first the type with sqlite3_column_type() and, if NULL, return NaN seems the most practicable one from a user's standpoint. A future sqlite3_column_double_v2() or another way to control the conversion of non-numeric values to double would be nice and appreciated perhaps by several other users, too.
/Stephan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users