Cindy Cwiertak 8.Jan.07 03:32 PM a Web browser LS:DO LS:DO - All Releases Windows 2000
I have written several scripts to go out and grab information within an SQL database and fill in the fields on the lotus notes form, however I am not able to do a sql stmt using the sum function. Below is part of the script showing what I am doing. I am not getting any error just no data. I have ran the SQL on my table and I receive data. Any suggestions would be appreciated.
qry.SQL = "SELECT SUM(Table1.NOTEBAL) FROM Table1 WHERE Table.Nbr ='123'"
Set res.Query = qry
If res.IsResultSetAvailable = True Then
res.MaxRows = 0
.balance = res.GetValue("NoteBal")
Loop Until res.IsEndOfData