Hello everyone
I am new to iphone database access. I am having database acess problem. Here is my code:
Code:
-(void)readFromDB
{
NSString *path = [[NSBundle mainBundle]pathForResource:@"asldb" ofType:@"sqlite"];
if(sqlite3_open([path UTF8String], &db) == SQLITE_OK){
NSString *str = [NSString stringWithFormat:@"SELECT id,signimg,name FROM tbl1 WHERE catname=Amount"];
NSLog(@"query=%@",str);
const char *statement = [str UTF8String];
sqlite3_stmt *compiled;
if(sqlite3_prepare_v2(db, statement, -1, &compiled, NULL) == SQLITE_OK){
while (sqlite3_step(compiled) == SQLITE_ROW) {
NSUInteger recordID = sqlite3_column_int(compiled,0);
NSLog(@"id=%d",recordID);
NSString *aName = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiled,2)];
NSLog(@"name:%@",aName);
// NSData *imgData = [[NSData alloc]initWithBytes:sqlite3_column_blob(compiled,4) length:sqlite3_column_bytes(compiled,4)];
//UIImage *img = [UIImage imageWithData:imgData];
//[signImage setImage:img];
//[imgData release];
sqlite3_finalize(compiled);
sqlite3_close(db);
}
}
}
}
but my NSlog is not firing.