How to save table column sqlite3 values in an array
<p>How to save a table column sqlite3 values in an array.</p>

<pre><code>tempQuery=[@"select * from iapp_tbl_cases where casenum=" 
             stringByAppendingString:[NSString stringWithFormat:@"%d",rowid]];

const char *query2=[tempQuery UTF8String];

if (sqlite3_prepare_v2(database,query2,-1,&amp;statement,NULL)==SQLITE_OK) {

    qt=[[[Question alloc]init]autorelease];
    while (sqlite3_step(statement)==SQLITE_ROW) {
        qt.cases=[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement,2)];
        return qt;
    }
</code></pre>

<p>Thanks in advance</p>
