How do you read floating numbers (REAL) from a sqlite database on the iphone?

Question

I need to read floating point decimals from sqlite db

I have created Variable type in database as INTEGER

I am reading with sqlite3_column_int to NSInteger variables

which parts should changed so i can read floating point integers from database

thanks for answers sorry im a newbie in this topics

Answer 1

There's no such thing as a floating-point integer. They're mutually exclusive on a fundamental level (well floating point numbers can fall on integer boundaries but you get the idea) :P.

But the way to get floats out is by using the sqlite3_column_double(sqlite3_stmt *, int) function.

NSNumber *f = [NSNumber numberWithFloat:(float)sqlite3_column_double(stmt, col)];

Answer 2

Declare the fields as a floating point number. From sqllite datatype doc the database type is REAL. This is a 8 byte floating point number which is an Objective-C double, NSDouble or NSNumber type.

Answer 3

NSNumber *num;
int temp = (float)sqlite3_column_double(walkstatement, 3);
num = [[NSNumber alloc]initWithInt:temp];
NSLog(@"%@",num);

This code worked for me..