Xref: alice comp.databases.oracle.tools:37286
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!news.algonet.se!algonet!masternews.telia.net!newsa.telia.net.POSTED!not-for-mail
From: "Lars Sjöström" <lasse.sjostrom@telia.com>
Newsgroups: comp.databases.oracle.tools
References: <835rq4$bpkd$1@reader1.wxs.nl>
Subject: Re: COMMIT recors instead of a complete form
Lines: 39
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <_Mz54.297$an3.189137408@newsa.telia.net>
Date: Tue, 14 Dec 1999 22:46:18 GMT
X-Complaints-To: abuse@telia.com
X-Trace: newsa.telia.net 945211578 195.198.40.73 (Tue, 14 Dec 1999 23:46:18 CET)
NNTP-Posting-Date: Tue, 14 Dec 1999 23:46:18 CET
Organization: Telia Internet

I believe that this could be solved with a call to the POST-procedure. It
POSTs changes to the database, but do not perform a COMMIT. But that might
not help, when I think about it more in detail...

Lars

Arie Mars skrev i meddelandet <835rq4$bpkd$1@reader1.wxs.nl>...
>Hello,
>
>Some questions about COMMIT
>
>1. Why is the message 'No changes to save' a popup-message sometimes,
>instead of a status-line message?
>
>2. I use a timer-trigger in my FORM to start an import procedure, running
in
>the background.
>    In this procedure I use some SQL code to INSERT the imported values
INTO
>the database.
>    After that I use a COMMIT. This will not only commit the new values,
but
>it tries to COMMIT
>    all datablocks (in fact the whole form). So when the user is modifying
>data on some
>   datablock/canvas at the same time, his/her changes will be committed too
>at that moment.
>   I don't want this. My procedure must commit its own records only.
>
>
>Thanks in advance
>
>Arie Mars
>arie@pca-online.nl
>
>
>