Reply to thread

Message

<blockquote data-quote="Hesse" data-source="post: 72167" data-attributes="member: 23814">I'm having some issues with SQLite and my class. Here is a portion of a class that I wrote called GENERAL_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[CODE]m_db = new SQLiteClient(databaseFile);[/CODE]with the exception[CODE]{&quot;Object reference not set to an instance of an object.&quot;}[/CODE]I thought that I was setting the instance there?? Can anyone help me out?Regards,Jesse--- GENERAL_DB class ----[CODE]using System;using System.Data;using System.Collections.Generic;using System.Collections;using System.Text;using System.Windows.Forms;using MediaPortal.Database;using SQLite.NET;namespace GUIXMM{&nbsp; public class GENERAL_DB&nbsp; {&nbsp; &nbsp; public SQLiteClient m_db = null;&nbsp; &nbsp; private bool dbExists;&nbsp; &nbsp; public GENERAL_DB()&nbsp; &nbsp; {&nbsp; &nbsp; }&nbsp; &nbsp; public void Open()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Attempt to open database&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; string fullpath = &quot;C:\\Program Files\\Team MediaPortal\\MediaPortal\\&quot;;&nbsp; &nbsp; &nbsp; &nbsp; string databaseFile = fullpath + &quot;database\\VideoDatabaseV5.db3&quot;;&nbsp; &nbsp; &nbsp; &nbsp; dbExists = System.IO.File.Exists(databaseFile);&nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(&quot;dBExists: &quot; + dbExists.ToString());&nbsp; &nbsp; &nbsp; &nbsp; m_db = new SQLiteClient(databaseFile);&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; }&nbsp; }}[/CODE]--- Separate function to create instance of GENERAL_DB ----[CODE]&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; &nbsp; GENERAL_DB myGENERAL_DB = new GENERAL_DB();&nbsp; &nbsp; &nbsp; myGENERAL_DB.Open();&nbsp; &nbsp; }[/CODE]</blockquote>

[QUOTE="Hesse, post: 72167, member: 23814"] I'm having some issues with SQLite and my class. Here is a portion of a class that I wrote called GENERAL_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 [CODE]m_db = new SQLiteClient(databaseFile);[/CODE] with the exception [CODE]{"Object reference not set to an instance of an object."}[/CODE] I thought that I was setting the instance there?? Can anyone help me out? Regards, Jesse --- GENERAL_DB class ---- [CODE]using System; using System.Data; using System.Collections.Generic; using System.Collections; using System.Text; using System.Windows.Forms; using MediaPortal.Database; using SQLite.NET; namespace GUIXMM { public class GENERAL_DB { public SQLiteClient m_db = null; private bool dbExists; public GENERAL_DB() { } public void Open() { // Attempt to open database try { // Open database MessageBox.Show("Open DB"); string fullpath = "C:\\Program Files\\Team MediaPortal\\MediaPortal\\"; string databaseFile = fullpath + "database\\VideoDatabaseV5.db3"; dbExists = System.IO.File.Exists(databaseFile); Console.WriteLine("dBExists: " + dbExists.ToString()); m_db = new SQLiteClient(databaseFile); 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); } } } }[/CODE] --- Separate function to create instance of GENERAL_DB ---- [CODE] 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(); GENERAL_DB myGENERAL_DB = new GENERAL_DB(); myGENERAL_DB.Open(); }[/CODE] [/QUOTE]

Verification