Code:
napFile = System.IO.Directory.GetCurrentDirectory() + "\\mypoc.sql";
StreamReader rid_s = new StreamReader(napFile, true);
kom.Connection = conn;
kom.CommandText = rid_s.ReadToEnd();
kom.ExecuteNonQuery();
napFile = System.IO.Directory.GetCurrentDirectory() + "\\mypoc.sql";
StreamReader rid_s = new StreamReader(napFile, true);
kom.Connection = conn;
kom.CommandText = rid_s.ReadToEnd();
kom.ExecuteNonQuery();
Mislim da je greska u cakrakteru koji odvaja naredbu od naredbe ?????
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]
You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near ';
CommandText = "USE KPI;\r\n\r\nCREATE TABLE godina (Godina varchar(4) NOT NULL, PRIMARY KEY (Godina) ); \r\nLOCK TABLES godina WRITE;\r\nINSERT INTO godina (Godina) VALUES ('2007');\r\nINSERT INTO godina (Godina) VALUES ('2008');\r\n\r\nUNLOCK TABLES;\r\n\r\nCREATE T...
ovdije se pojavljuju \n\r koje nikako ne mogu izbaciti
[Ovu poruku je menjao Neznalica_sa_ugla dana 23.08.2008. u 15:43 GMT+1]