title: How to use TClientDataSet with SQL Server view? (Or alternative)
body: <p>In my form I have <code>TADOQuery,TDataSetProvider,TClientDataSet,TDataSource,TDBGrid</code> linked. </p>
  
  <p>AdoQuery  use SQL Server view to query data</p>
  
  <p><code>AdoQuery.SQL</code>:  </p>
  
  <pre><code>Select * from vu_Name where fld=:fldval
  </code></pre>
  
  <p>Vu_Name:  </p>
  
  <pre><code>SELECT * FROM  t1 INNER JOIN t2 ON t2.fld1 = t2.fld1
  </code></pre>
  
  <p>in my dbgrid, only columns in table t1 are editable.(only t1 need to update )</p>
  
  <p>What are the possible (fastest) ways to apply updates back to the server?
  <code>ClientDataSet.ApplyUpdates(0); // not working</code></p>
  
  <p>Thank you.</p>