Re: FRM-41003

[Quoted] 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.

[Quoted] "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. Received on Fri Nov 14 2003 - 23:07:03 CET