Re: updating fields through Form

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 18 Apr 1999 04:35:51 GMT
Message-ID: <7fbnf7$b7r$1_at_nntp.csufresno.edu>


In article <371770b3.30936880_at_news.netnitco.net>, Keith Svetlin <fraggle__at_hotmail.com> wrote:
>On Fri, 16 Apr 1999 17:16:21 GMT, fraggle__at_hotmail.com (Keith Svetlin)
>wrote:
>I am using Oracle Developer 2000 with it's form builder and such just
>for clarification. Thanx.
>
>
>>I am a student working on a case study working on a project as a
>>pseudo-DBA. My team is trying to update fields in a form we created
>>through the use of triggers. Every time we go to save however we
>>receive an Insert error FRM-40508 I believe the number is. What is
>>the correct trigger(if any) to use when doing this type of
>>updating/inserting from the form. A statement claims ot update but
>>then we get the Insert error.

In the Form, when you get the 40508 message, press Shift-F1 (or Help --> Display Error on the menu) to see the underlying error message returned from the server.

You probably have an item in you base-table block that is not a base-table column, but have not set its base-table-item property to false.

Steve Cosner



http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Sun Apr 18 1999 - 06:35:51 CEST

Original text of this message