>> If you do not know what type is _actually_ stored, call >> sqlite3_column_type() first. > > That looks like one call to get the type, a choice of 3 calls for > INTEGER, REAL or TEXT and a choice of 3 conversion/casts to get it to > the final type
>>>If you want to get out a value for a specific final type, just call the appropriate sqlite3_column_xxx() function for that. For numbers, that would be _int or _int64 or _double. The 'specific final type' is decimal, with 30 digits precision. Sqlite doesn't support that. Pity. IMHO it should. Regards David M Bennett FACS Andl - A New Database Language - andl.org