DataTable* table = [_db  ExecuteQuery:@"SELECT firstname , lastname , age , salary FROM person"];

NSLog(@"Columns in query");
for (NSString* colName in table.columns)
    NSLog(@"%@",colName);


for (NSArray* row in table.rows)
{
    NSString* firstname = row[0]; // in column order 0 is first column in query above
    NSString* lastname = row[1];
    NSNumber* age = row[2]; // sqlite ints and floats arrive as NSNumbers
    NSNumber* salary = row[3];
}

NSString* firstname =   table.rows[1][0]; // row 2 col 1 - zero based
NSString* lastname =    table.rows[1][1]; // row 2 col 2
NSNumber* age =         table.rows[1][2]; // row 2 col 3
NSNumber* salary =      table.rows[1][3]; // row 2 col 4

//Scalar 1 result returned
int personCount = [_db  ExecuteScalar:@"SELECT count(*) FROM person" asInt:YES];

// UPDATE command
int rowsaffected = [_db  ExecuteNonQuery:@"UPDATE person set salary = 20000 WHERE lastname = 'smith'"];

// INSERT - returning New Auto Increment ID
int DBID = [_db  ExecuteINSERT:@"INSERT INTO person(firstname,lastname,age,salary) VALUES('sue','peterson',32,15123.39)"];


//Delete - returning how many rows affteced by delete
int rowsaffected = [_db  ExecuteNonQuery:@"DELETE FROM person WHERE lastname = 'smith'"];

@property (strong, nonatomic) DBController* db;

#import "DBController.h"
#import "DataTable.h"

//synthesize the iVar
@synthesize db=_db;

//Set up DB connection
self.db = [DBController sharedDatabaseController:@"DataTable.sqlite"]; // Change DB name to your name here


//Execute Command
DataTable* table = [_db  ExecuteQuery:@"SELECT firstname , lastname , age , salary FROM person"];

// list out values

for (NSArray* row in table.rows)
{
    
    NSString* firstname = row[0]; // in column order 0 is first column in query above
    NSString* lastname = row[1];
    NSNumber* age = row[2]; // sqlite ints and floats arrive as NSNumbers
    NSNumber* salary = row[3];
    
    
    NSLog(@"row:%i %@ %@ %@ %@",
          [table.rows indexOfObject:row]+1, /*zero based*/
          firstname,
          lastname,
          age,
          salary);
    
}