Reply to thread

Message

<blockquote data-quote="Hesse" data-source="post: 71899" data-attributes="member: 23814">SQLite ProblemsI'm having some issues with SQLite and my class.&nbsp; Here is a portion of a class that I wrote called VIDEO_DB which is supposed to be the class which can access the SQLite DB.&nbsp; I have a separate test block of code which attempts to create an instance of this class and open the database as shown.However, when I run the code, I get an exception that I can't understand why its occurring.&nbsp; When I run in debug mode and step through, it bombs on the line&nbsp; &nbsp; &nbsp; &nbsp; m_db = new SQLiteClient(&quot;VideoDatabaseV5.db3&quot;);with the exception{&quot;Object reference not set to an instance of an object.&quot;}I thought that I was setting the instance there??&nbsp; Can anyone help me out?Regards,Jesse---- VIDEO_DB class -----namespace GUIXMM{&nbsp; /// &lt;summary&gt;&nbsp; /// Class VIDEO_DB description&nbsp; /// &lt;/summary&gt;&nbsp; public class VIDEO_DB&nbsp; {&nbsp; &nbsp; public bool op_update = false;&nbsp; &nbsp; public bool op_copy = false;&nbsp; &nbsp; public bool op_image = false;&nbsp; &nbsp; public bool op_format = true;&nbsp; &nbsp; public bool op_actorInfo = false;&nbsp; &nbsp; public int op_actorNum = 1;&nbsp; &nbsp; public bool stopRebuild = false;&nbsp; &nbsp; public ProgressBar progressBar = null;&nbsp; &nbsp; public Label label1 = null;&nbsp; &nbsp; public Label label2 = null;&nbsp; &nbsp; &nbsp; &nbsp; //private static SQLiteClient m_db = null;&nbsp; &nbsp; public SQLiteClient m_db = null;&nbsp; &nbsp; //SQLiteClient m_db;&nbsp; &nbsp; //IDbConnection dbcon = null;&nbsp; &nbsp; //private static string m_db = null;&nbsp; &nbsp; private bool dbExists;&nbsp; &nbsp; //------------------------------------------------------------------------------&nbsp; &nbsp; // Open DB and initialize tables&nbsp; &nbsp; //------------------------------------------------------------------------------&nbsp; &nbsp; public void Open()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; //SQLiteClient m_db;&nbsp; &nbsp; &nbsp; //SQLiteResultSet results;&nbsp; &nbsp; &nbsp; //SQLiteClient m_db = null;&nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; // Open database&nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;Open DB&quot;);&nbsp; &nbsp; &nbsp; &nbsp; //System.IO.Directory.CreateDirectory(&quot;database&quot;);&nbsp; &nbsp; &nbsp; &nbsp; //dbExists = System.IO.File.Exists(@&quot;database\VideoDatabaseV5.db3&quot;);&nbsp; &nbsp; &nbsp; &nbsp; string fullpath = &quot;C:\\Program Files\\Team MediaPortal\\MediaPortal\\&quot;;&nbsp; &nbsp; &nbsp; &nbsp; string database = fullpath + &quot;database\\VideoDatabaseV5.db3&quot;;&nbsp; &nbsp; &nbsp; &nbsp; dbExists = System.IO.File.Exists(database);&nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(&quot;dBExists: &quot; + dbExists.ToString());&nbsp; &nbsp; &nbsp; &nbsp; //m_db = new SQLiteClient(&quot;test.db&quot;);&nbsp; &nbsp; &nbsp; &nbsp; m_db = new SQLiteClient(&quot;VideoDatabaseV5.db3&quot;);&nbsp; &nbsp; &nbsp; &nbsp; //m_db = new SQLiteClient(@&quot;database\VideoDatabaseV5.db3&quot;);&nbsp; &nbsp; &nbsp; &nbsp; //m_db = new SQLiteClient(database);&nbsp; &nbsp; &nbsp; &nbsp; ArrayList tables = m_db.GetColumn(&quot;SELECT name FROM sqlite_master WHERE type = 'table'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; foreach (string tableName in tables)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(&quot;\t&quot; + tableName);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if (!dbExists)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(&quot;DB does not exist, creating tables.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CreateTables();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; catch (SQLiteException ex)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(&quot;Fatal error: {0}&quot;, ex.Message);&nbsp; &nbsp; &nbsp; &nbsp; Log.Write(&quot;XMMdatabase exception err:{0} stack:{1}&quot;, ex.Message, ex.StackTrace);&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }--- Test Function to create instance of VIDEO_DB class and open DB ----&nbsp; &nbsp; private void button_debug_VIDEO_DB_Click(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; string fullpath = &quot;C:\\Program Files\\Team MediaPortal\\MediaPortal\\&quot;;&nbsp; &nbsp; &nbsp; string database = fullpath + &quot;database\\VideoDatabaseV5.db3&quot;;&nbsp; &nbsp; &nbsp; //MessageBox.Show(database);&nbsp; &nbsp; &nbsp; if (File.Exists(database))&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;File: &quot; + database + &quot; exists&quot;);&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;File: &quot; + database + &quot;was not found.&quot;);&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; VIDEO_DB myVIDEO_DB = new VIDEO_DB();&nbsp; &nbsp; &nbsp; myVIDEO_DB.Open();&nbsp; &nbsp; }</blockquote>

[QUOTE="Hesse, post: 71899, member: 23814"] [b]SQLite Problems[/b] I'm having some issues with SQLite and my class. Here is a portion of a class that I wrote called VIDEO_DB which is supposed to be the class which can access the SQLite DB. I have a separate test block of code which attempts to create an instance of this class and open the database as shown. However, when I run the code, I get an exception that I can't understand why its occurring. When I run in debug mode and step through, it bombs on the line m_db = new SQLiteClient("VideoDatabaseV5.db3"); with the exception {"Object reference not set to an instance of an object."} I thought that I was setting the instance there?? Can anyone help me out? Regards, Jesse ---- VIDEO_DB class ----- namespace GUIXMM { /// <summary> /// Class VIDEO_DB description /// </summary> public class VIDEO_DB { public bool op_update = false; public bool op_copy = false; public bool op_image = false; public bool op_format = true; public bool op_actorInfo = false; public int op_actorNum = 1; public bool stopRebuild = false; public ProgressBar progressBar = null; public Label label1 = null; public Label label2 = null; //private static SQLiteClient m_db = null; public SQLiteClient m_db = null; //SQLiteClient m_db; //IDbConnection dbcon = null; //private static string m_db = null; private bool dbExists; //------------------------------------------------------------------------------ // Open DB and initialize tables //------------------------------------------------------------------------------ public void Open() { //SQLiteClient m_db; //SQLiteResultSet results; //SQLiteClient m_db = null; try { // Open database MessageBox.Show("Open DB"); //System.IO.Directory.CreateDirectory("database"); //dbExists = System.IO.File.Exists(@"database\VideoDatabaseV5.db3"); string fullpath = "C:\\Program Files\\Team MediaPortal\\MediaPortal\\"; string database = fullpath + "database\\VideoDatabaseV5.db3"; dbExists = System.IO.File.Exists(database); Console.WriteLine("dBExists: " + dbExists.ToString()); //m_db = new SQLiteClient("test.db"); m_db = new SQLiteClient("VideoDatabaseV5.db3"); //m_db = new SQLiteClient(@"database\VideoDatabaseV5.db3"); //m_db = new SQLiteClient(database); ArrayList tables = m_db.GetColumn("SELECT name FROM sqlite_master WHERE type = 'table'"); foreach (string tableName in tables) { Console.WriteLine("\t" + tableName); } if (!dbExists) { Console.WriteLine("DB does not exist, creating tables."); CreateTables(); } } catch (SQLiteException ex) { Console.WriteLine("Fatal error: {0}", ex.Message); Log.Write("XMMdatabase exception err:{0} stack:{1}", ex.Message, ex.StackTrace); } } --- Test Function to create instance of VIDEO_DB class and open DB ---- private void button_debug_VIDEO_DB_Click(object sender, EventArgs e) { string fullpath = "C:\\Program Files\\Team MediaPortal\\MediaPortal\\"; string database = fullpath + "database\\VideoDatabaseV5.db3"; //MessageBox.Show(database); if (File.Exists(database)) { MessageBox.Show("File: " + database + " exists"); } else { MessageBox.Show("File: " + database + "was not found."); } VIDEO_DB myVIDEO_DB = new VIDEO_DB(); myVIDEO_DB.Open(); } [/QUOTE]

Verification