I want to check if the table exists.But return is 0.

netpyoung / SqlCipher4Unity3D

💾 SqlCipher made easy for Unity3d

MIT License

163 stars 37 forks source link

I want to check if the table exists.But return is 0. #9

Closed HHHHHHHHHHHHHHHHHHHHHCS closed 6 years ago

HHHHHHHHHHHHHHHHHHHHHCS commented 6 years ago

    SQLiteCommand cmd = new SQLiteCommand(Connection)
    {
        CommandText = @"select count(*) from sqlite_master where type='table' and name='mytest01'"
    };
    var li = cmd.ExecuteQuery<int>()[0];
        Debug.Log(li);

HHHHHHHHHHHHHHHHHHHHHCS commented 6 years ago

ExecuteScalar thank you for your code