Problem sensind Transactions

[raulbolanos]

Hi guys,

I want to send this transaction but I got an error.


string cmdString = @"IF (5 > 0) SELECT dbIndex FROM VerCommonHeader WHERE productNumber = 'XyX' AND internalSerialNumber = 'A1B2C3' AND rtsStatus = 2";

MySqlCommand command = new MySqlCommand(cmdString, m_connection);
ActivateDatabaseApplicationRole();
using (transaction = m_connection.BeginTransaction())
{
Trace.WriteLine("\n\nBEGIN INSERT\n\n");
//AC foreach (OleDbCommand command in sqlCommands)
foreach (MySqlCommand command in sqlCommands)
{
Trace.WriteLine(command.CommandText);
command.Transaction = transaction;
command.ExecuteNonQuery();
}
transaction.Commit();
}
transaction = null;


whather that an IF or Variable declaration I get this error: "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 'IF (5 > 0) BEGIN PRINT 'hallo' END"..........

what do you think?

thank you.