Re: just commiting at update

"aditya gangadharam via OracleMonster.com" <forum_at_OracleMonster.com> wrote in message news:f4db45c854294b5f914d414fc3ac2ebf_at_OracleMonster.com...
> hi all,
>
> i am using oracle forms 9i and i want to update a record so i am searching
> a record using the do_key('Execute_Query') and not by saying the
> execute_query or Enter_query this is how i am fetching my records and if i
> say commit_form on another button(for update only) says that unique key
> constraint voilation.
>
> So, how can i update records with out saying the update or enter_query or
> Execute_query
>
> regards
>
> aditya
>
> --
> Message posted via http://www.oraclemonster.com

you're not running into a forms or update problem -- you're runing into a database constaint problem

take a look at the error message (display error on the help menu as i recall) for the name of the unique constraint, and trace that back through the data dictionary (or the developer who created the table and constraints) to find out what column you've got a bad value in (duplicate of a value currently in the database)

++ mcs Received on Tue Jan 18 2005 - 09:04:26 CST