Re: FRM-41003

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

[Quoted] 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. Received on Sat Nov 15 2003 - 23:23:34 CET