Run command activity error

Hello

I will insert data into the data table using database ‘Run Command’ activity but some error occur. I have shared screenshot below.
plz check and help me how can resolve.

sql query:

Insert Into [dbo].[APInvoiceProcessStatus] ([PONumbers],[InvoiceNumber],[InvoiceDate],[InvoiceAmount],[DebitOrCredit1],[DebitOrCredit2],[ProcessFlag],[Exception],[Status],[DateTime]) VALUES (‘“+vPONum(0).tostring.trim+”’,‘“+vInvoiceNum(0).tostring.trim+”’,‘“+vInvoiceDate(0).tostring.trim+”’,‘“+vTotalAmount(0).tostring.trim+”’,‘Null’,‘Null’,‘InProgress’,‘“+In_CurrentDate+”’)

Thanks
Minal Patil

@minal.patil

The query should be in string format enclose the query in double quotes

Cheers

thanks it is solve

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.