OraFAQ Forum: Forms » frm-30113 Block must have non query only database item Block:block2

Home » Developer & Programmer » Forms » frm-30113 Block must have non query only database item Block:block2 (oracle forms 6i,apps 11.5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

frm-30113 Block must have non query only database item Block:block2 [message #425997]

Tue, 13 October 2009 10:46

consultant19
Messages: 23
Registered: September 2009
Location: India

Junior Member

Hi

I have created a custom form which has 2 tabs

on first tab(tab1) it has 2 blocks (block1,block2)
both the blocks are based on one table(table1)

table1 is a custom database table

block1 based on table1
block2 based on table1

block1 & block2 are like MASTER-DETAIL relationship,but ididnt use Master-detail relation ship.Instead i used When new record instance. it worked for me

when ever i insert some thing in block1,should be reflected in block2.block2 is read only.no one can insert & update in block2

every thng working fine

after compiling,it generates fmx as well as error

frm:30113 block must have non query only database item
BLOCk:Block2

Please help me

Thanks

Report message to a moderator

Re: frm-30113 Block must have non query only database item Block:block2 [message #426024 is a reply to message #425997]

Tue, 13 October 2009 16:29

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

I am guessing...

1) your form is trying to update a field on block2 even though your block is readonly.

2) your form is trying to lock the row referenced by block2 event though your block is readonly.

3) there are incompatible settings for your block and its fields.

Did you do any googles?

1...

2...

A pretty obscure error. Not much on the web.

Kevin

[Updated on: Tue, 13 October 2009 16:29]

Report message to a moderator

Re: frm-30113 Block must have non query only database item Block:block2 [message #426441 is a reply to message #426024]

Thu, 15 October 2009 08:41

consultant19
Messages: 23
Registered: September 2009
Location: India

Junior Member

Hi Kevin

Thanks for your help.
I solved the problem

in my second block i.e block2 ---all fields initially
it was query allowed-yes,query only--yes

I changed it to query allowed-no,query only--yes
for all fields in my block

Report message to a moderator

Re: frm-30113 Block must have non query only database item Block:block2 [message #426443 is a reply to message #425997]

Thu, 15 October 2009 08:43

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Nice detective work dude. Good job.

And a big thanks to you for posting back your answer. It is when people like you take the time to post back your solution that these forums really become a help to others.

Again good work, come back soon.

Kevin

Report message to a moderator

Previous Topic:	Requirement to enable auditing on every form in Oracle apps 11i,Dynamically
Next Topic:	arabic language

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:38:52 CDT 2024