OraFAQ Forum: Forms » How to use group by command in forms 6i

Home » Developer & Programmer » Forms » How to use group by command in forms 6i

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

How to use group by command in forms 6i [message #529118]

Fri, 28 October 2011 14:16

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How to use group by command in forms 6i

Report message to a moderator

Re: How to use group by command in forms 6i [message #529123 is a reply to message #529118]

Fri, 28 October 2011 14:26

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

Senior Member
Account Moderator

What do you mean, "how to use it"? The way the syntax says, I suppose.

Report message to a moderator

Re: How to use group by command in forms 6i [message #529127 is a reply to message #529123]

Fri, 28 October 2011 14:31

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

select a.voc_no,sum(nvl(b.quantity,0)) from pur_master a,pur_detail b
where a.voc_no=b.voc_no group by a.voc_no

this command working properly in sql but error generate in forms trigger

Report message to a moderator

Re: How to use group by command in forms 6i [message #529129 is a reply to message #529127]

Fri, 28 October 2011 14:34

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

Senior Member
Account Moderator

Only if we knew which error ...

Report message to a moderator

Re: How to use group by command in forms 6i [message #529136 is a reply to message #529127]

Fri, 28 October 2011 15:12

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

ORA-01422 ??

Report message to a moderator

Previous Topic:	Question: Non database block item value passing to query up records
Next Topic:	forms 6i compatible issue with Win XP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 13:06:33 CDT 2024