Home » Developer & Programmer » Forms » group by data block
group by data block [message #234717] Thu, 03 May 2007 00:50 Go to next message
zshanalig1
Messages: 4
Registered: March 2007
Location: pakistan
Junior Member
AS SALAM O ALAIKUM!
HOW ARE U?
WELL I WANT TO SET THE DATA BLOCK GROUP BY CLAUSE SO HOW CAN I DO THAT IN FORM 6I PLZ REPLY ME AS SOON AS POSSIBLE

THANX
ZEESHAN HUSSAIN
Re: group by data block [message #234780 is a reply to message #234717] Thu, 03 May 2007 02:43 Go to previous messageGo to next message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Create a block manually
Set Query Data Source Type to From Clause Query
In Query Data Source Name write your SQL statement . in my case it is (SELECT DEPTNO , SUM(SAL) SAL FROM EMP GROUP BY DEPTNO)
Create two items Deptno - Database Item with Column Name Deptno, Sal - Database Item with Column name Sal and set deptno as primary key. Run the form and execute query. Hope this is what your requirement.
Re: group by data block [message #235248 is a reply to message #234780] Fri, 04 May 2007 08:59 Go to previous message
zshanalig1
Messages: 4
Registered: March 2007
Location: pakistan
Junior Member
thank you very much for your kind reply
this was what i needeed may god bless u
Previous Topic: Oracle forms force date validation
Next Topic: Query by date only
Goto Forum:
  


Current Time: Fri Dec 09 23:24:31 CST 2016

Total time taken to generate the page: 0.09859 seconds