Karsten Farrell wrote:
> carlene_at_tobedebtfree.com said...
>
>>I have created a form in Oracle 9i that inserts a record into a
>>database. When I click save, it works fine. So I made a submit
>>button with a when_button_pushed trigger. the code is
>>Insert into members values(:members.user_id, etc.)-im positive the
>>code is right! When i run this code i get a error that states my
>>primary key constraint is prohibiting me from inserting. So I took
>>off the constraint, and found that it was inserting two records at the
>>same time. Does anyone know why this is happening, and if so can you
>>PLEASE tell me how to fix it.
>>
>>Thanks!
>>
>
> If your code isn't doing it, then it sounds suspiciously like a database
> trigger being fired. Try:
>
> select trigger_name from all_triggers
> where table_name = 'MEMBERS';
that, or you do not post all of your code... is there a commit, too?
Then that's the answer - you already inserted (forms did...), and you
insert again. Actually, all you need is a commit_form;
--
Regards, Frank van Bortel
Received on Sun Apr 13 2003 - 08:12:26 CDT
