[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

missing frm-40301:query caused no record to be retrieved. Re-enter

Posted on 2009-04-28
8
Medium Priority
?
6,669 Views
Last Modified: 2013-12-19
I am using Oracle 8i and application version is 11.0.300.

I have a form, when I query the form from menu (query->enter), in the tool bar, it has the following message.

"Enter a query; please Ctrl+F11 to execute, F4 to Cancel"


when I input an ID in search field and select (query->run) and it return nothing to the form, the tool bar message is still


"Enter a query; please Ctrl+F11 to execute, F4 to Cancel"


But, it's supposed to have the following message in the tool bar if return nothing.

frm-40301:query caused no record to be retrieved. Re-enter


why missing frm-40301:query caused no record to be retrieved. Re-enter

Please help me fix. Thanks a lot
0
Comment
Question by:wasabi3689
  • 4
  • 4
8 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 24257476
after you input the id, can you press ctrl + f11 instead of query -> run and see whether you get the message in the tool bar.
0
 

Author Comment

by:wasabi3689
ID: 24261482
The tool bar still has the same message


"Enter a query; please Ctrl+F11 to execute, F4 to Cancel"

But it seems when I hit query->run, I feel the id refresh, but using Ctrl-f11, no change at all
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 24265994
i dont remember the short cut key for putting the form into enter query mode. instead of pressing query -> enter can you use the short key to put the form into enter query mode and then input some id and then ctrl + f11.

I am not sure whether i remember it correct or not, i think the short cut key is f11 to put the form into enter query mode.

also what form is that ? does that belong INV or WIP or FLM or BOM or to what product does that belong ?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:wasabi3689
ID: 24267203
i  can use the short-cut key Ctrl-F11...  to switch between representing "enter-query" and "run query"

but, I always have "Enter a query; please Ctrl+F11 to execute, F4 to Cancel"

not have
"frm-40301:query caused no record to be retrieved. Re-enter"

if return nothing for the form.
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 24267341
also what form is that ? does that belong INV or WIP or FLM or BOM or to what product does that belong ?
0
 

Author Comment

by:wasabi3689
ID: 24271847
what do you mean "INV or WIP or FLM or BOM"?

The form I use is a custom form, not a built-in form.

Please provide more information for solution at one post. I am in  a hurry need for a fix.

Thanks
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 24271881
oh..ok...i thought there is some issue with the form you are using. I do not have developer 6i installed here and hence i cannot help much here.

I worked on D2K .. 5 years before and cannot guess what the issue could be.
0
 

Accepted Solution

by:
wasabi3689 earned 0 total points
ID: 24307383
I found the solution. Just remove on-message trigger completely. After that, it works.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question