Sorry! Resend an email because no subject in previous email.
Again. Your help is greatly appreciated.
Thanks,
JP



----- Original Message ----
From: Joanne Pham <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Thursday, August 21, 2008 11:54:13 AM
Subject: [sqlite] (no subject)

Hi All,
I have a question related toSQLite db handle(pDb in my codes).
I have the function below to open the database connection. I have to  call 
sqlite3_close(sqlite3 *)(sqlite3_close(pDb) in my case)
before open another  database connection( by calling openDb) for releasing the 
memory which is used by previous sqlite3_open_v2(openDb). Otherwise the 
protential memory leak will be in the codes.
Your response is greatly appreciated.
JP
MonDb::openDb(const char *dbName){
  int sqlSt;
  const char* errMsg;  
  strcpy(name, dbName); //copy database name to the private name field
  sqlSt = sqlite3_open_v2( name, &pDb, SQLITE_OPEN_READWRITE | 
SQLITE_OPEN_CREATE, 0); 
  if(sqlSt != SQLITE_OK){
    errMsg = sqlite3_errmsg(pDb);
    // print out the error message
    sqlite3_free((char*) errMsg);
    return false;
   }
   /* Set database properties for better performance */
   setDbProperties();
  return true;
}


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



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

Reply via email to