How to get integer value from Sqlite Database?

Question

I am working with Sqlite Database.

In my database

I have some filed Like, Invoice,Name,Date

My Invoiceno datatype is INTEGER,

In Select query Got output like this.

 Query:(
    {
     InvoiceNo = 1;
     Name : ABC
     Date = "2012-04-16 00:00:00";

    }
  )

But when try to Get that Invoice no to string it's given Diff. Value.

Code for getting invoice from array to String:

  NSString *str = [NSString stringWithFormat:@"%i",[[Query objectAtIndex:indexPath.row] valueForKey:@"InvoiceNo"]];
    NSLog(@"str:%@",str);

Here, My invoice no is 1, & It's give me a value "2387056"

Please, Help me..How can i solve this problem?

[NSString stringWithFormat:@"%d",[[Query objectAtIndex:indexPath.row] valueForKey:@"InvoiceNo"]]; maybe it will help you. — ChintaN -Maddy- Ramani
– ChintaN -Maddy- Ramani, Commented Apr 16, 2012 at 13:06
@chinttu Thanks for Answer,it's given me other string value... — Anki
– Anki, Commented Apr 16, 2012 at 13:08
@Anki you have to do %d or doin typecast "intValue" .. maybe it will help. u got answer? — ChintaN -Maddy- Ramani
– ChintaN -Maddy- Ramani, Commented Apr 16, 2012 at 13:10

Narayana Rao Routhu · Accepted Answer · 2012-04-16 13:07:40Z

2

NSString *str = [NSString stringWithFormat:@"%i",[[Query objectAtIndex:indexPath.row] valueForKey:@"InvoiceNo"]];
    NSLog(@"str:%@",str);
you have to replace above lines with below lines

NSString *str = [NSString stringWithFormat:@"%i",[[[Query objectAtIndex:indexPath.row] valueForKey:@"InvoiceNo"] intValue]];
    NSLog(@"str:%@",str);

answered Apr 16, 2012 at 13:07

Narayana Rao Routhu

6,31329 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devang · Accepted Answer · 2012-04-16 13:08:31Z

1

Convert NSString to int

NSString *values = @"1";

int yourValue = [values intValue];

NSLog(@"Int Value : %d",yourValue);

answered Apr 16, 2012 at 13:08

Devang

11.3k13 gold badges64 silver badges101 bronze badges

Collectives™ on Stack Overflow

How to get integer value from Sqlite Database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related