Re: FRM-21011, unhandled exception ora-00984

You forget to put : before tbl_books_isbn.isbn_no

jan

mjenson43_at_cambridgecollege.edu (Maria J) wrote in message news:<8c2afc9c.0408171658.34d6b8fb_at_posting.google.com>...
> Hi everyone,
>
> I have the following code on a button on my form, which works in
> runtime. The form is based on different data tables, but two fields
> are going into a differnt table when the button is clicked.
>
> INSERT into tbl_wish_list(cust_id,isbn_no)
> VALUES(:global.c_id,:tbl_books_isbn.isbn_no);
> commit;
>
> I created a menu to make the form look better, and put the code in the
> menu as follows:
> INSERT into tbl_wish_list(cust_id,isbn_no)
> VALUES(:global.c_id,tbl_books_isbn.isbn_no);
> (when compiling, I wasn't able to leave the : in front of the isbn
> field)
>
> When I use the button on the form, the data saves to the table, but I
> get "FRM-21011, unhandled exception ORA-00984" when I use the same
> functionality on the menu.
>
> What obvious thing am I missing???
Received on Wed Aug 18 2004 - 05:18:12 CDT