From: richard@somewhere.net   
      
   Hi,   
      
      
   I work on a VB6 software using ADO to connect to Oracle 9.2i.   
      
   When I create a recordset based on a query containing a "inner join" clause   
   (sql server syntax, the software connects also to sql server and the "inner   
   join" syntax must be preserved for a large fraction of the queries), AddNew   
   and Update methods fail.   
      
   Initially, I was using the MSDAORA provider ... With this provider, the   
   BASETABLENAME property of each fields of the recordset  is wrong. All fields   
   are considered as belonging to the same table and the recordset is thus not   
   updatable.   
      
   So I have changed the provider to OraOLEDB.Oracle ... With this provider the   
   BASETABLENAME is correct, each field is associated with its origin table BUT   
   the Update and AddNew still fail :(   
      
   Any solution ?   
   Is it definitively impossible to update "inner join" recordsets ?   
      
      
   Thank you for your help,   
      
   Richard   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)