Creating Tables

Good Resources https://www.sqlite.org/lang_createtable.html An Example bool DatabaseSqlite::InitialiseDatabase(void) { System::Data::SQLite::SQLiteConnection ^Connection1; String ^sTemp; try { //—– OPEN THE DATABASE CONNECTION —– Connection1 = gcnew System::Data::SQLite::SQLiteConnection(“data source=” + Environment::GetFolderPath(Environment::SpecialFolder::ApplicationData) + “\\” + Application::CompanyName + “\\” + Application::ProductName + “\\mydatabasefile.db;Password=” + SQLITE_DATABASE_FILE_PASSWORD); Connection1->Open(); System::Data::SQLite::SQLiteCommand ^Command1 = gcnew System::Data::SQLite::SQLiteCommand(Connection1); //—– CREATE MY TABLE IF NECESSARY —– sTemp = “CREATE […]

Read More