title: FireDac DApt 400
body: <p>I use "XE6" and "MySQL" database. I have only one table. The primary key is auto increment. When I insert a record it generates an error: "[FireDac] [DApt] -400. Fetch command fecthed [0] instead of <a href="http://docwiki.embarcadero.com/RADStudio/Seattle/en/Tracing_and_Monitoring_(FireDAC)" rel="nofollow noreferrer">1</a> record. Another user ".</p>
  
  <p>My table has primary key and there is no other connection to the database. Anyone have any idea what that might be?</p>
  
  <p>My code:</p>
  
  <pre><code>AbrirConexao; // Open connection
  fQryTransacao.Close;
  fQryTransacao.SQL.Text := 'SELECT * FROM APOLICE LIMIT 0'; // I dont use a script SQL. I load the structure of table. Then I enter the table.
  fQryTransacao.Open;
  fQryTransacao.Insert;
  CarregarQuery(pApolice, fQryTransacao); // It takes the value of an object and assigns it in the "fields" of the query.
  fQryTransacao.Post; // Here it generates the error.
  EncerrarConexao; // Close connection
  </code></pre>
  
  <p>I used "TFDMoniFlatFileClientLink" to monitor the SQL commands. The generated LOG file has the generated "insert" command. If I copy and execute directly in "MySQL" does not generate error.</p>
  
  <p><a href="http://docwiki.embarcadero.com/RADStudio/Seattle/en/Tracing_and_Monitoring_(FireDAC)" rel="nofollow noreferrer">Tracing and Monitoring (FireDAC)</a></p>