[sqlite] Error handling

[Igor Korot]

Hi, ALL,
Consider the following pseudo-code:

[code]
int ret = sqlite3_prepare_v2();
if( ret != SQLITE_OK )
{
// henerate error message
return 1;
}
while( ; ; )
{
    ret = sqlite3_step();
    if( ret == SQLITE_ROW )
    {
// everything is good
    }
    else if( ret == SQLITE_DONE )
        break;
    else
    {
        result = 1;
        break;
    }
}
if( ret != SQLITE_DONE )
    return 1;
// everything is good - continue processing
[/code]

My question is: how many calls to "sqlite3_finalize() should be there?

Do I need one inside lines 2-6? And how to properly handle failure with
statement release?

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users