Help getting the following create table function to work with mysql and C# [closed]

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

---

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 8 years ago.

Improve this question

string createTable = "CREATE TABLE IF NOT EXISTS " + m_strDatabase + "_TimeLogs (logName VARCHAR(16), logTime INTEGER, logCountry TEXT, UNIQUE(logName)) TYPE=MyISAM;";

Wh开发者_开发技巧en this runs, no table is created. No errors either.

Im using an ODBC connector.

the variable passes in the db name, so that the table created would be users_TimeLogs if the database was called users for example.

Am I doing something wrong?

---

I'd forgotten that way way above in my code I had a constraint to only run if a list.count > 0, and since I'm only testing at this stage the list was empty..