OraFAQ Forum: Forms » frm-40735

Home » Developer & Programmer » Forms » frm-40735 (oracle forms 10g)

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

frm-40735 [message #551058]

Sun, 15 April 2012 04:54

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

hi all

i am facing a problem.i hav a master detail form. my 'select into' has to fectch more than one record in detail which is tabular.

it giving error(FRM-40735:WHEN-MOUSE-CLICK TRIGGER raised unhandled exception ORA-01422).

so please guide me how to handle it.
thanks in advance

Report message to a moderator

Re: frm-40735 [message #551059 is a reply to message #551058]

Sun, 15 April 2012 05:06

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why are you using a select to populate the detail block at all?
Why aren't you using the default query functionality?

Report message to a moderator

Re: frm-40735 [message #551060 is a reply to message #551059]

Sun, 15 April 2012 05:14

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

WHEN IAM USING EXECUTE_QUERY IT FETCHES ALL RECORDS.
BUT I HAVE WHERE CONDITION IN MY 'SELECT INTO' THATS WHY..

THANKS FOR RESPONSE...

HELP ME

Report message to a moderator

Re: frm-40735 [message #551062 is a reply to message #551060]

Sun, 15 April 2012 05:24

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Posting in UPPER case is viewed as shouting and rude.
If you shout against people do not expect to have their help.

Regards
Michelm

Report message to a moderator

Re: frm-40735 [message #551063 is a reply to message #551062]

Sun, 15 April 2012 05:34

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

oops...iam really sorry ...i really dont know about this.
thanks

Report message to a moderator

Re: frm-40735 [message #551066 is a reply to message #551063]

Sun, 15 April 2012 07:02

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

So why not set the where clause in the datablock properties? That's what it is there for.

Report message to a moderator

Re: frm-40735 [message #551069 is a reply to message #551066]

Sun, 15 April 2012 07:59

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

i tried as u said..
if iam giving any condition in where clause of data block properties no record is getting fetch.

thanks

[Updated on: Sun, 15 April 2012 08:03]

Report message to a moderator

Re: frm-40735 [message #551070 is a reply to message #551069]

Sun, 15 April 2012 08:04

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you post (copy/paste) a WHERE clause you entered into data block's WHERE clause property? Please, enclose it into the [code] tags.

P.S. As your (detail) data block is based on a table now, executing a query is similar to

select * from detail_table;

executed in SQL*Plus. Now you add a WHERE clause to your query. If it returns *something* in SQL*Plus, is will return the same data set in Forms too:

select * from detail_table
where <your clause goes here>

[Updated on: Sun, 15 April 2012 08:07]

Report message to a moderator

Re: frm-40735 [message #551071 is a reply to message #551070]

Sun, 15 April 2012 08:14

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

bill_id=:ship_mstr.bill_id and rec_qty=null or rec_qty!=send_qty

this is my where clause.

Report message to a moderator

Re: frm-40735 [message #551073 is a reply to message #551071]

Sun, 15 April 2012 08:20

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I suppose you didn't try this clause in SQL*Plus, did you?

= null

is never true. With NULL, you have either

rec_qty IS NULL

rec_qty IS NOT NULL

So, what happens if you modify it like this?

[Updated on: Sun, 15 April 2012 08:21]

Report message to a moderator

Re: frm-40735 [message #551074 is a reply to message #551073]

Sun, 15 April 2012 08:24

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

i will try and let you know...
thankx

Report message to a moderator

Re: frm-40735 [message #551099 is a reply to message #551073]

Sun, 15 April 2012 11:24

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

It Worked.....!!!

i really you all very much for you help.really helpful..

thank a lot dear all..thanks....

Report message to a moderator

Previous Topic:	Ora-06511 - Cursor already open - Trigger raised unhandled exception.
Next Topic:	two database list item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:26:42 CDT 2024