Home » Developer & Programmer » Forms » frm-30113 Block must have non query only database item Block:block2 (oracle forms 6i,apps 11.5.10)
frm-30113 Block must have non query only database item Block:block2 [message #425997] Tue, 13 October 2009 10:46 Go to next message
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


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 Go to previous messageGo to next message
Kevin Meade
Messages: 2098
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 Go to previous messageGo to next message
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


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 Go to previous message
Kevin Meade
Messages: 2098
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
Previous Topic: Requirement to enable auditing on every form in Oracle apps 11i,Dynamically
Next Topic: arabic language
Goto Forum:
  


Current Time: Mon Sep 26 12:48:02 CDT 2016

Total time taken to generate the page: 0.06523 seconds