Hello all,

I have my SQLite db setup in such a way that my ID column is a primary key and it gets generated automatically by the db incrementally after each INSERT.  The code looks something like this

String sqlStatement;
DbStatement* pStmt = null;
DbEnumerator* retVal = 0;
Database* db;
result r = E_SUCCESS;

sqlStatement.Append(L"INSERT INTO Track (Description, Title, Distance, Status) VALUES (?,?,?,?)");

db = BootstrapManager::getInstance()->getDatabase();
pStmt = db->CreateStatementN(sqlStatement);
pStmt->BindString(0, *__pDescription);
pStmt->BindString(1, *__pTitle);
pStmt->BindDouble(2, __distance);
pStmt->BindInt(3, __status);

AppLog("Performing transaction with statement: [%d]", statement);
db->BeginTransaction();
retVal = db->ExecuteStatementN(*statement);
db->CommitTransaction();