Venice
Purch::SeekBySupRef
 
Seeks a Purchase Document by its supplier reference.
 
VARIANT_BOOL SeekBySupRef (
    enum eSeekMode eSeekMode,
    LONG lSupNum,
    BSTR bsReference
)
 
Key information
This method uses key number 9 (See SwapKey).
This key allows duplicates.
 
Key segment information
Segment NameTypeOrderCollation
pSupNumLONG (unsigned)Ascending-
pSupRefBSTRAscendingCase insensitive
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
lSupNum
[in] The supplier number of the Purchase Document you want to seek.
bsReference
[in] The reference of the Purchase Document you want to seek.
 
Return value
True if the record with the given properties was found, otherwise false.
 
See Also
CreatePurch
GetDBStatus
GetNext
 
Samples
 
C++
 
// Seek all Purchase Documents of supplier with number 125 with no supplier reference
long lSupNum = 125;
pPurch->SeekBySupRef (smEqual, lSupNum, "");
while (pPurch->GetDBStatus () == 0 && (long)pPurch->pSupNum == lSupNum && (CString)pPurch->pSupRef == "")
{
    // Process record data

    pPurch->GetNext ();
}

C#
 
// Seek all Purchase Documents of supplier with number 125 with no supplier reference
int iSupNum = 125;
oPurch.SeekBySupRef (eSeekMode.smEqual, iSupNum, "");
while (oPurch.GetDBStatus () == 0 && (int)oPurch.pSupNum == iSupNum && oPurch.pSupRef.ToString () == "")
{
    // Process record data
    
    oPurch.GetNext ();
}

VBS
 
' Seek all Purchase Documents of supplier with number 125 with no supplier reference
Dim iSupNum
iSupNum = 125
Call oPurch.SeekBySupRef(smEqual, iSupNum, "")
While oPurch.GetDBStatus() = 0 And oPurch.pSupNum = iSupNum And oPurch.pSupRef = ""
    ' Process record data

    Call oPurch.GetNext()
Wend

VB.NET
 
' Seek all Purchase Documents of supplier with number 125 with no supplier reference
Dim iSupNum As Integer
iSupNum = 125
oPurch.SeekBySupRef(eSeekMode.smEqual, iSupNum, "")
While oPurch.GetDBStatus() = 0 And oPurch.pSupNum = iSupNum And oPurch.pSupRef = ""
    ' Process record data

    oPurch.GetNext()
End While