Hi I have a scripted activity which export Notes docs into DB2.
I have two connection for that:
srcCon = Notes
detCon = DB2
I have the following for Notes Connection:
Set srcCon = New LCConnection ("notes")
srcCon.Server = db.Server
srcCon.Database = db.FilePath
srcCon.Metadata = "PVApproval"
srcCon.Condition = "Status = 2"
count = srcCon.Select (Nothing, 1,fetchLst)
This should get all documents with form = "PVApproval" and Status = 2
The code above works fine but only if is executed using the debuger; if I run this as Schedule Agent or from the Notes client using the option RunOnServer then count alway returns 0.
Does it sound familiar to someone?