Home » Developer & Programmer » Forms » Unable to query a view datablock (forms6i)
Unable to query a view datablock [message #427471] Thu, 22 October 2009 15:21 Go to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

I recently created a view and built a forms 6i search screen for it. I am trying to query the view for a specific item number but I keep getting "No Data Found" when I hit the execute button, any ideas? P.S. the item number does exist because I can query in Toad and able to view the results in the same View table.
Re: Unable to query a view datablock [message #427476 is a reply to message #427471] Thu, 22 October 2009 15:50 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Actually the error says

FRM-40301 Query caused no records to be retrieved
Re: Unable to query a view datablock [message #427478 is a reply to message #427476] Thu, 22 October 2009 15:57 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
Could it be a privileges issue?
Re: Unable to query a view datablock [message #427479 is a reply to message #427478] Thu, 22 October 2009 16:00 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

How can I check? A privilege on the form itself?
Re: Unable to query a view datablock [message #427481 is a reply to message #427479] Thu, 22 October 2009 16:19 Go to previous message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Problem fixed now, thanks, you were right, the form did nto have priviledges.
Previous Topic: Change object name case
Next Topic: Form is automatically closing after commit
Goto Forum:
  


Current Time: Fri Dec 02 16:31:29 CST 2016

Total time taken to generate the page: 0.30630 seconds