Can I have multiple tables in one database?

[giantkiller]

I know this question sounds silly...

I have 2 tables in one DB.

In my accessing GameObject I have two scripts both pointing to same instance of DBmanager in hierarchy.

The first table [pricing] query(not shown here) displays fine but the second table [industry] query access produces:

public class Industrydata
{
   [Default("'No description'")]
   public string Industry { get; set; }
   [Default("0")]
   public int ColorNumber { get; set; }
}




string sql = "SELECT " + "I.Industry, " +
                            "I.ColorNumber " +
                            "FROM industryGroup I";
       

A debug.log display string SQL Statement: SELECT I.Industry, I.ColorNumber FROM industryGroup I
UnityEngine.Debug:Log(Object)
IndustryRead:Start() (at Assets/Scripts/IndustryRead.cs:17)

SQLiteException: no such table: industryGroup
SimpleSQL.SQLite3.Prepare3 (IntPtr db, System.String query)
SimpleSQL.SQLiteCommand.Prepare3 ()
SimpleSQL.SQLiteCommand.ExecuteQuery[Industrydata] (SimpleSQL.TableMapping map)
SimpleSQL.SQLiteCommand.ExecuteQuery[Industrydata] ()
SimpleSQL.SQLiteConnection.Query[Industrydata] (System.String query, System.Object[] args)
SimpleSQL.SimpleSQLManager.Query[Industrydata] (System.String query, System.Object[] args)
IndustryRead.Start () (at Assets/Scripts/IndustryRead.cs:19)

Any ideas?

Thanks.

[echo17]

This sounds like it relates to this FAQ: link

[giantkiller]

That did it. Thanks. This is the second time this bit me.