title: Select Count(*) returning old value from before deleting all the entries in a data table
body: <p>So I inserted some data on my table, ran a Select Count(*) query, and showed the result, it was 120, then I deleted the data of the table from sqldeveloper, ran my VB project again with the same query as before just to test if it worked ok, and to my surprise it returned the same value as before! Still 120, although the same exact Select Count query does return 0 from sqldeveloper, I already closed the project and opened it again, no change. What could be happening?</p>
  
  <p>This is my query code:</p>
  
  <pre><code>sql.CommandText = "select count(*) from mytable"
  sql.CommandType = CommandType.Text
  sql.Connection = conexion.con
  test = Convert.ToInt32(sql.ExecuteScalar().ToString())
  TextBox1.Text = test.ToString()
  </code></pre>
  
  <p>test is an Integer variable, the reason I convert it to an Integer is because I want to evaluate the result and decide what to do based on the number returned by the query.</p>
  
  <p>VB.NET 3.5 and Oracle10g XE</p>