Home » Developer & Programmer » Forms » Query caused no records to be retrieved
Query caused no records to be retrieved [message #134697] Fri, 26 August 2005 04:56 Go to next message
vaidehee
Messages: 1
Registered: August 2005
Location: India
Junior Member
hi

i have a table called purchase_order_m. it has data in it. but whenever i open the purchase_order_form and give execute_query it gives this message.

FRM-40350: Query caused no records to be retrieved.

Please help!

Report message to a moderator

Re: Query caused no records to be retrieved [message #134894 is a reply to message #134697] Sun, 28 August 2005 18:23 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please review the 'default where' property of your block. Also search your form for the command 'set_block_property' and determine if there is a 'default_where' override coded in the form.

Alternatively, use a tool like TOAD to review 'open cursers' and have a look at what your form has requested.

David

Report message to a moderator

Previous Topic: create button to search
Next Topic: frm-40501
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:03:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.