2. ASPRunnerPro General questions
  3. [SOLVED]  Coverting 'Sum' Query to DAL
This topic is locked
[SOLVED]

 Coverting 'Sum' Query to DAL

 		1/8/2012 10:30:36 PM
ASPRunnerPro General questions
ZeinzuKun author

Hello,
Is there a way to covert SQL Statements that uses 'Sum' Function to DAL Methods?
Example: Select Sum(col2) from table where col1 = <somevalue>
col1 holds the common field while col2 holds the value
All I know is that it can make 'Select' Queries and returns a set.
Thanks.
Sergey Kornilov admin 1/9/2012

Well, you can use the following:

set rs= CustomQuery("Select Sum(col2) from table where col1 = <somevalue>")
ZeinzuKun author 1/10/2012



Well, you can use the following:

set rs= CustomQuery("Select Sum(col2) from table where col1 = <somevalue>")



Ok, I got it. Thanks.