Re: Forms and commit
Date: Mon, 15 Oct 2001 03:53:40 GMT
Message-ID: <85ty7.67286$Xk4.4970124_at_news1.rdc1.sdca.home.com>
"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message
news:CxHx7.2144$M6.573191_at_news1.news.adelphia.net...
> If I take out the commit I still get problem #1, but problem #2 is cured.
A form by default determines if any records/fields in the form have been changed from what's in the database and the commit is based on that. You are either getting a "no changes to commit" message that you haven't mentioned, or your :SYSTEM.MESSAGE_LEVEL setting is suppressing it.
In other words, Forms is happy with a COMMIT basic commit if:
- The record in the form came from the database to begin with and has been modified or deleted.
and/or
2. The record entered in the form is inserted due to the form's block and items corresponding to database items and it issues its own INSERT statement behind the scenes rather than you explicitly issuing one.
I haven't worked with a form such as this so I don't know the exact solution, but you're doing something a little different from usual. I see that Mike posted an answer though - see if that works out for you.
-Matt Received on Mon Oct 15 2001 - 05:53:40 CEST