How to substitute integer variable in update query in Lotusscript?

HCL Domino Domino Forum
1

Dear all,

I want to update the rows in sqlserver from lotusscript using update query.

I can substitute string and boolean value successfully with covered like [‘“+stringvalue+”’], But i cant figure it for Integer. i tried various combinations, it fails.

code snippets:

Dim PKMMSendEmailLogSysID As Integer

PKMMSendEmailLogSysID = result.GetValue(“PK_MM_SendEmailLog_SysID”)

Updateqry.SQL =" UPDATE [AskHR].[dbo].[MM_SendEmailLog] SET [IsMailSent] = 1 WHERE PK_MM_SendEmailLog_SysID =‘“+PKMMSendEmailLogSysID+”’"

Thanks

2

Subject: integers don’t need quotes

You need to wrap strings in quotes, but not numbers:

Updateqry.SQL = "UPDATE [AskHR].[dbo].[MM_SendEmailLog] SET [IsMailSent] = 1 WHERE PK_MM_SendEmailLog_SysID = "+ PKMMSendEmailLogSysID