Cindy Cwiertak 8.Jan.07 03:32 PM a Web browser LS:DOLS:DO - All ReleasesWindows 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
res.Execute
If res.IsResultSetAvailable = True Then
Do
res.MaxRows = 0
With doc
res.NextRow
.balance = res.GetValue("NoteBal")
.save True,False
End With
Loop Until res.IsEndOfData
Return to top
Select SUM SQL Statement (Cindy Cwiertak 8.Jan.07)
. . 
Print this page
