sum value in sql statement

#1

How do i get the value of TotalQty from the sql string to
lblCouponNum.text

Dim sqlstr As String
sqlstr = "select sum (NumberofCoupons) as TotalQty from
tmpInputData"
Dim sqlAdapter As Odbc.OdbcDataAdapter = New
Odbc.OdbcDataAdapter(sqlstr, connDB)

#2

jonathandrott (AT) gmail (DOT) com wrote:

Quote:

How do i get the value of TotalQty from the sql string to
lblCouponNum.text

Dim sqlstr As String
sqlstr = "select sum (NumberofCoupons) as TotalQty from
tmpInputData"
Dim sqlAdapter As Odbc.OdbcDataAdapter = New
Odbc.OdbcDataAdapter(sqlstr, connDB)

Looks like this is not a SQL question, but a host language question. Is
that VB? then look for a VB discussion group.
Ed

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sum value in sql statement

comp.databases comp.databases

sum value in sql statement - 10-23-2006 , 01:33 PM

Re: sum value in sql statement - 10-24-2006 , 07:08 AM