search

Busta117 / SQLiteUnityKit

Framework to connect with a SQLite database from Unity for iOS, Android, MAC , Windows
300 stars 77 forks source link

Getting Bool #9

Open afavar opened 9 years ago

afavar commented 9 years ago

Hi, how can i get the boolean value in my database column?

SqliteDatabase sqlDB = new SqliteDatabase ("config.db"); string query = "SELECT bookName ,read " + "FROM Books"; var data = sqlDB.ExecuteQuery (query); bool boolData = data.Rows[0]["read"];

Currently it returns data.Rows[0]["read"] as object so it gives me an error: Cannot implicitly convert type object' tobool'. An explicit conversion exists (are you missing a cast?)

isaacgoodfellow commented 8 years ago

Sqlite has no internal representation for boolean values, but they can be represented with integers,

bool read = ((int)result.Rows [i] ["read"]) > 0;

would suffice in this case