views:

23

answers:

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

When 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?

A: 

Creating table and inserting records are different things. Do you have enough rights to create table?

Riho
yeah I do, it executes perfectly through phpMyAdmin.. Just not when running in the C# code.
Matt
A: 

sorry, I was being retarded..

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

Thanks for the help..

Matt
You should mark this answer as accepted.
svick
"I didn't include [the rest of the code] because I know that bit works"... :D
Paolo