Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group By a query item

Status
Not open for further replies.

seemap

Programmer
Aug 22, 2007
9
US
Hi All
How do i group by a query item in a query subject in Framework manager?
Thanks
SP
 
Do you mean that you want to use an aggregate SQL expression (where a 'group by' is mandatory)?



Ties Blom

 
I have a SQL expression which i want to use in Framework Model. This expression has 'Group By' in it.
So how do i do the same in the model. Do i use the determinants for this?
Thanks
SP
 
Nope, a group by indicates an aggregate (if you are using SQL properly) You should define this as a query subject in the datalayer.


Ties Blom

 
Thanks Blom,
Can you elaborate how to define this as a query subject in the database layer. I am new to this tool.
SP
 
When you create a new query subject you have 3 options:

(1) Model (based on existing objects)
(2) Manually build an SQL query
(3) Stored procedure

In your case use option 2..

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top