title: Database change not recognized by ADO using Delphi and SQL Server
body: <p>I run a small db application with 2 <code>TADOConnection</code> to my SQL Server. The first connection is just for viewing purpose using <code>ADOTable</code>, <code>Datasource</code> and <code>DBNavigator</code>.
  The second connection is created at run time using the following code</p>
  
  <pre><code>aConnection:=TADOConnection.create(nil);
  
  aTable:= TADOTable.create(nil);
  aConnection.LoginPrompt := false;
  
  .....
  aTable.Edit;
  
  aTable.Insert;
  
  aTable.FieldByName(' ... ').AsInteger :=  .... ;
  
  aTable.FieldByName(' .... ').AsString :=  ... ;
  
  aTable.FieldByName(' .... ').AsString :=  ..... ;
  
  aTable.Post;
  
  aTable.active := false;
  
  aConnection.connected :=false;
  
  aTable.free;
  
  aConnection.free;
  </code></pre>
  
  <p>If I insert records with this code I can't see the changed data if I press the Update Navigator button. I need to restart my application to see all my new inserted data. 
  Why is the first dbconnection not recognizing the changes made my the second connection ?</p>