Re: Updates Through Views DBv9.2.0.2

Lisa,

      MS Access has a problem updating linked tables without primary keys. When you create the link it asks you for a unique identifier, if you pick a column, you should then be able to update through the view.

HTH,
Mike

                                                                                       
                                                
                      "Lisa R. Clary"                                                  
                                                
                      <[EMAIL PROTECTED]        To:       Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>                   


                      >                        cc:                                     

                                                
                      Sent by:                 Subject:  Updates Through Views 
DBv9.2.0.2                                              
                      [EMAIL PROTECTED]                                                
                                                
                      .com                                                             
                                                
                                                                                       
                                                
                                                                                       
                                                
                      06/25/2003 01:09                                                 
                                                
                      PM                                                               
                                                
                      Please respond to                                                
                                                
                      ORACLE-L                                                         
                                                
                                                                                       
                                                
                                                                                       
                                                

I am trying to use a 3rd party tool via odbc (or other means) to perform updates to a single oracle table through a view using a gui front end. I have been successful at doing the updates through a view using sql worksheet or sql editor in toad, but can't get it to update using ms access or the schema browser in toad (really would prefer using access linked tables), it just 'dings' basically indicating it can't do it. If I pull in the underlying table (as a linked table), I can update that just fine through ms access, but it allows for all other fields to be updated by the user and not just a select few.

The ultimate goal is to create a view with subsets of the underlying table to which only 2 of the 5 columns of the view can be updated. Even though I have granted perms on the view itself including grant update (modifier, date_rec) on test_table to dms, no luck, I still am missing something. Any ideas?

thanks,

lc

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lisa R. Clary
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Boligan
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).