Xref: alice comp.databases.oracle.misc:30585 comp.databases.oracle.server:48364
Path: alice!news-feed.fnsi.net!netnews.com!news-xfer.newsread.com!netaxs.com!newsread.com!peerfeed.news.psi.net!psinntp!pubxfer.news.psi.net!client.news.psi.net.POSTED!not-for-mail
From: "Brad Pybus" <brad_pybus_nospam@hotmail.com>
Newsgroups: comp.database.oracle,comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Oracle Trigger causing change error in Access. help.
Lines: 35
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <2A3Y2.124$MR2.110380@client.news.psi.net>
Date: Wed, 05 May 1999 22:26:06 GMT
NNTP-Posting-Date: Wed, 05 May 1999 18:26:06 EDT
Organization: PSINet

I have an Oracle database using an Oracle ODBC driver to connect to an MS
Access front end.

I wrote a "BEFORE" trigger "FOR EACH ROW" that will do the following:

:NEW.RecordChangedDate := SYSDATE;

--------------

The problem is, when I open the table in Access, and edit a field (not
"RecordChangedDate") then move to another
record and edit that same field, I almost always get the following error:


        The data has been changed.

        Another user edited this record and saved changes before you
attempted to save your changes.

        re-edit the record.



I then try to edit that field again and it works just fine.
I know its being caused by the trigger because when I delete the trigger,
the problem goes away.

How do I always get the Oracle database to update the timestamp for a record
when somebody edits the record without causing this error?

--
To reply to me, remove the "_nospam" from my address.