Re: Forms 4.5: Using 'commit;' in a trigger.
From: <emma_at_netone.com.tr>
Date: 14 Mar 2000 08:52:50 GMT
Message-ID: <8akul2$43u$1_at_news.netmar.com>
In a previous article, Erika Grondzakova <Erika.Grondzakova_at_cern.ch> writes:
>Hello,
>
>I have had the same problem few minutes ago. I found out that
>Forms_DDL('COMMIT') helped me...
>
>Hth,
>
>Erika
>
>
>Martyn Dissington wrote:
>>
>> I would like to use a when-button-pressed trigger to insert a line into
>> a table. When the trigger is getting to the line 'Commit;' the user is
>> shown the message 'FRM-40401: No changes to save.' as there have been no
>> changes to the current block.
>>
>> But if i take out 'Commit;' the line that is inserted does not get
>> saved. How do i saved this insert without doing a commit_form;
>>
>> thanks in advance,
>>
>> Martyn.
>>
>> --
>> Could any replies be CC'd to
>> < mdiss2bu_at_burton-college.ac.uk >
Hi
Date: 14 Mar 2000 08:52:50 GMT
Message-ID: <8akul2$43u$1_at_news.netmar.com>
In a previous article, Erika Grondzakova <Erika.Grondzakova_at_cern.ch> writes:
>Hello,
>
>I have had the same problem few minutes ago. I found out that
>Forms_DDL('COMMIT') helped me...
>
>Hth,
>
>Erika
>
>
>Martyn Dissington wrote:
>>
>> I would like to use a when-button-pressed trigger to insert a line into
>> a table. When the trigger is getting to the line 'Commit;' the user is
>> shown the message 'FRM-40401: No changes to save.' as there have been no
>> changes to the current block.
>>
>> But if i take out 'Commit;' the line that is inserted does not get
>> saved. How do i saved this insert without doing a commit_form;
>>
>> thanks in advance,
>>
>> Martyn.
>>
>> --
>> Could any replies be CC'd to
>> < mdiss2bu_at_burton-college.ac.uk >
Hi
You can set :system.message_level := 5 ;
Assigning 5 to :system.message_level suppress message which is not database related.
- Posted via NewsOne.Net: Free Usenet News via the Web -----
- http://newsone.net/ -- Discussions on every subject. ----- NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net