I have an integration (GP2010) I inherited that used to properly update a SQL table with the value "READ" after a document has been successfully integrated.
The script is as follows:
Dim GP
Set objRec = CreateObject("ADODB.Recordset")
GP = Sourcefields("PORECEIPTS_LINES.PONO")
sSQL = "Update RBI_POReceipts set ReadByGP = 'READ' where PONO= '" & GP & "'"
Set objRec = GetVariable("Connection").Execute(sSQL)
Does anybody have any thoughts? Does anybody have an example of a script they use that I could review?