SOrder::SeekByOpenStatCst (Interface: SOrder)
 
Seeks an unpaid Sales Order by its customer number.
 
VARIANT_BOOL SeekByOpenStatCst (
    enum eSeekMode eSeekMode,
    LONG lCstNum,
    BSTR bsBook,
    LONG lDocNum
)
 
Key information
This method uses key number 6 (See SwapKey).
This is a unique key.
This is a null key, only the records where pIsOpen is true are in the index.
 
Key segment information
Segment NameTypeOrderCollation
pCstNumLONG (unsigned)Ascending-
pBookBSTRAscendingCase insensitive
pDocNumLONG (unsigned)Ascending-
pIsOpenVARIANT_BOOLAscending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
lCstNum
[in] The customer number of the Sales Order you want to seek.
bsBook
[in] The book code of the Sales Order you want to seek.
lDocNum
[in] The document number of the Sales Order you want to seek.
 
Return value
True if the record with the given properties was found, otherwise false.
 
See Also
CreateSOrder
GetDBStatus
GetNext
 
Samples
 
C++
 
// Process all records that are still open
pSOrder->SeekByOpenStatCst (smFirst, 0, "", 0);
while (pSOrder->GetDBStatus () == 0)
{
    // Process record data

    pSOrder->GetNext ();
}

// Check if the document for the Customer with number 25 and with book code = 'Book' and document number = 12 is still open
if (pSOrder->SeekByOpenStatCst (smEqual, 25, "Book", 12))
    // Record is still open

C#
 
// Process all records that are still open
oSOrder.SeekByOpenStatCst (eSeekMode.smFirst, 0, "", 0);
while (oSOrder.GetDBStatus () == 0)
{
    // Process record data

    oSOrder.GetNext ();
}

// Check if the document for the Customer with number 25 and with book code = 'Book' and document number = 12 is still open
if (oSOrder.SeekByOpenStatCst (eSeekMode.smEqual, 25, "Book", 12))
    // Record is still open

VBS
 
' Process all records that are still open
Call oSOrder.SeekByOpenStatCst(smFirst, 0, "", 0)
While oSOrder.GetDBStatus() = 0
    ' Process record data

    Call oSOrder.GetNext()
Wend

' Check if the document for the Customer with number 25 and with book code = 'Book' and document number = 12 is still open
If oSOrder.SeekByOpenStatCst(smEqual, 25, "Book", 12) Then
    ' Record is still open
End If

VB.NET
 
' Process all records that are still open
oSOrder.SeekByOpenStatCst(eSeekMode.smFirst, 0, "", 0)
While oSOrder.GetDBStatus() = 0
    ' Process record data

    oSOrder.GetNext()
End While

' Check if the document for the Customer with number 25 and with book code = 'Book' and document number = 12 is still open
If oSOrder.SeekByOpenStatCst(eSeekMode.smEqual, 25, "Book", 12) Then
    ' Record is still open
End If