Oracle Forms (MOSC)

MOSC Banner

Updating too many records

edited Oct 1, 2009 2:12AM in Oracle Forms (MOSC) 9 commentsAnswered
Help please,

I do not understand why this is occurring. I added a pre-update trigger to a datablock to insert updated_by and updated_date to the table when the record is updated. This works fine except when the user execute query to show all records and hits arrows to go through each record, if the user updates record 3, the updated columns are changed on record 1 and 2 as well. Any suggestions on how to update only the current record?
  

forms6i

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center