Table 'x' was not locked with LOCK TABLES

[raulbolanos]

Hi,

I am facing a strange problem with this code.

command.CommandText = PmdConstStrings.GetSqlStatement(PmdSqlStatements.GetMaxVerificationIndex);
return (int)command.ExecuteScalar();
 

where CommandText get the value 'SELECT indexValue FROM Indexes;\nUPDATE Indexes set indexValue = indexValue + 1'

Like you can see I send this query to the DB and I expect and int value but an exception occurs.

If I type the Query manually in SQLyog it shows the value and it's also increased

+-------------+
| indexValue |
+-------------+
| 3 |
+-------------+


with ExecuteScalar it takes the first column of the first row, should I add something else to the line to take the value 3 from the column?

What do you think? with this exception happend?

By the way I have already restart the computer several times and this keep happening.

Best Regards,
Raul

[r035198x]

The SELECT returns a value and so does the UPDATE. Which result are you expecting, the select one or the update one?
Split the statements and pass them separately.