'CustomWhereClause to load the Gift Collection with just
'the gifts from the posted batch
'sBatchName is the Batch Number, note if it is a recurring
'batch than it is for the original batch, not as it is
'being committed
Dim sWhereClause As String
sWhereClause = "Batch_Number='" & sBatchName & "'"
Dim oGifts As CGifts
Set oGifts = New CGifts
oGifts.Init REApplication.SessionContext, tvf_Gift_CustomWhereClause, sWhereClause
Debug.Print oGifts.Count
Dim oGift As CGift
'Loop through the gifts
For Each oGift In oGifts
'System ID of the Gift - this is the back end ID
Debug.Print oGift.Fields(GIFT_fld_ID)
oGift.CloseDown
Next oGift
'Clean up
oGifts.CloseDown
Set oGifts = Nothing
End Sub
Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Microsoft Visual Basic and the tools used to create and debug procedures. Our Customer Support can help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality. If you are interested in learning more about the VBA and API modules, contact your account manager.