Re: FRM-41003

Frank <fbortel_at_nescape.net> wrote in message news:<bp7son$3et$1_at_news2.tilbu1.nb.home.nl>...
> young_at_heart.com wrote:
>
> > On Fri, 14 Nov 2003 14:35:27 -0800, Daniel Morgan
> > <damorgan_at_x.washington.edu> wrote:
> >
> >
> >>Mr E Guest wrote:
> >>
> >>
> >>>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1068833309.278248_at_yasure>...
> >>>
> >>>
> >>>>Mr E Guest wrote:
> >>>>
> >>>>
> >>>>>Forms, Shmorms...
> >>>>>
> >>>>>So, I've got a database block based on a table in Forms 6i. The
> >>>>>Database properties appear to be fine. The user has access to the
> >>>>>table. All the items are database data items and the block itself is
> >>>>>a database data block.
> >>>>>
> >>>>>Why, then, do I get FRM-41003? (which suggests the block is a control
> >>>>>block).
> >>>>>
> >>>>>Maybe it's the alcohol abuse...
> >>>>>
> >>>>>Shaun.
> >>>>
> >>>>Why do you assume a 41003 means it is a control block? In fact why
> >>>>do you assume that 41003 is a valid error message from which we can
> >>>>help you? ;-)
> >>>>
> >>>>Please repost the exact error message with text.
> >>>
> >>>
> >>>"FRM-41003: This function cannot be performed here."
> >>>
> >>>OK - Apologies - I was assuming that if FRM-41003 meant nothing to the
> >>>reader then they probably would be unable to help.
> >>>
> >>>The Oracle Forms Error Messages book suggested the control block, but
> >>>Forms itself hinted at the fact that the table may not exist. Neither
> >>>of which are true (honest). The same user in SQL*Plus can describe
> >>>and issue statements against the tanle in question. And it's in the
> >>>Database Objects section of Forms.
> >>>
> >>>The table name and columns are correctly spelt and the block/item
> >>>properties are seemingly set for a database data block, not a control
> >>>block. This error occurs irrespective of which text item I issue
> >>>ENTER_QUERY from (or any other DML built-in).
> >>>
> >>>Shaun.
> >>
> >>This error message is very generic and does not indicate anything
> >>about the funtion being attempted nor do you indicate what the user
> >>is doing when they get the message? Query? Insert? Update? Delete?
> >>Are there any procdures or functions or LOVs with a record group?
> >>involved? Did it ever work? What was changed?
> >>
> >>Can you provide some specifics? I'd like to help you but I am still
> >>very unclear about what is going on.
> >
> >
> > Daniel,
> >
> > This is a new project. No database operations can be performed
> > anywhere in the block - you get this message every time. The form has
> > no LOVs or Record Groups as yet. It's not as though we've just
> > started developing using Forms (v2.3, v3, v4.5, v6 and 13 years
> > later!).
> >
> > I'll do a code labotomy on Monday and see what happens - bizarrely
> > 're-creating' the form by transplanting all the objects and properties
> > from the original has resolved a similar peculiarity in the past (in
> > v6 also, v4.5 seemed more sane!).
> >
> > Many thanks,
> >
> > Shaun.
> >
> Are you using Headstart by any chance?
> If so, there might be an attempt to fill static LOV's, while the
> cursor is actually in the control block (the control block has scope).
> Used to be a quite common source for this error, and was logged as a bug.

I'm afraid I'm not using Headstart. As this form is very embryonic. I've even eliminated the control block to sede what happens - no change.

Shaun. Received on Mon Nov 17 2003 - 08:26:48 CET