CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Create a group by in SQL

Print topic Send  topic

Author Message
Jomary
Posted: 04/26/2002, 7:55 AM

How I create a group by in CodeCharge Studio(Beta)?
Nicole
Posted: 04/26/2002, 8:04 AM

Jomary,
create Security Group in Project Settings window/Security Group tab (select menu item Project->Settings to access it). To create group enter Group name and GroupID.
Jomary
Posted: 04/26/2002, 9:08 AM

My questions is not for the Security Group, my question is, How I can group field when I have relation between two or more tables in the same SQL query?
Nicole
Posted: 04/29/2002, 3:02 AM

Jomary,
in this case use SQL as Data Source Type (select it from Data Source type list in Data Source window) and add Group By clause to sql query.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.