FRM 40508 Oracle error
From: <analyst_user_at_my-dejanews.com>
Date: Mon, 03 May 1999 22:01:08 GMT
Message-ID: <7gl6b2$okh$1_at_nnrp1.dejanews.com>
[Quoted] I have a form that has a block based on a table. This block contains a field which is used to find matches within that table, for example the same last name.
Date: Mon, 03 May 1999 22:01:08 GMT
Message-ID: <7gl6b2$okh$1_at_nnrp1.dejanews.com>
[Quoted] I have a form that has a block based on a table. This block contains a field which is used to find matches within that table, for example the same last name.
If there aren't any records found that match the last name and if I do a commit, the record gets inserted 2x. If there is a match then I receive the FRM 40508 error when trying to insert.
The table does not have any unique indexes. All fields that are required are populated. When I try inserting the same information manually in SQL Plus the record is inserted without a problem.
Any ideas on what might be wrong?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 00:01:08 CEST