Re: [U2] Group By equiv?

2005-07-21 Thread Allen Egerton
From: Jeff Powell [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, July 21, 2005 8:45 AM Subject: RE: [U2] Group By equiv? Kevin, You are right it is a Prelude system. We don't have this data normalized anywhere else so I still need to find a creative solution here

RE: [U2] Group By equiv?

2005-07-21 Thread Kevin King
It's not in the MAJOR.GRP file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Thursday, July 21, 2005 6:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Group By equiv? Kevin, You are right it is a Prelude system. We don't

RE: [U2] Group By equiv?

2005-07-21 Thread Jeff Powell
, 2005 6:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Group By equiv? Kevin, You are right it is a Prelude system. We don't have this data normalized anywhere else so I still need to find a creative solution here. Thanks anyway. --- u2-users mailing list u2-users

[U2] Group By equiv?

2005-07-20 Thread Jeff Powell
Is there a UniQuery equivalent to the SQL GROUP BY clause? I've tried SSELECT with UNIQUE but it saves only one attribute and then I cannot subsequently list other attributes. UniData version 5.2 UniObjects for Java Web Servlet application. Regards. --- u2-users mailing list

RE: [U2] Group By equiv?

2005-07-20 Thread Kevin King
] On Behalf Of Jeff Powell Sent: Wednesday, July 20, 2005 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Group By equiv? Is there a UniQuery equivalent to the SQL GROUP BY clause? I've tried SSELECT with UNIQUE but it saves only one attribute and then I cannot subsequently list other attributes

RE: [U2] Group By equiv?

2005-07-20 Thread Jeff Powell
. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Wednesday, July 20, 2005 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Group By equiv? Is there a UniQuery equivalent to the SQL GROUP BY clause? I've tried SSELECT with UNIQUE

RE: [U2] Group By equiv?

2005-07-20 Thread Kevin King
, 2005 5:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Group By equiv? Kevin, I have a file that has every product category attributes for: product line, product description (16,736 of these), major product group, major group description (133 of these). I want just the major group data