Venice
SOrder::SeekByOpenStatus
 
Seeks an unpaid Sales Order by its book and document number.
 
VARIANT_BOOL SeekByOpenStatus (
    enum eSeekMode eSeekMode,
    BSTR bsBook,
    LONG lDocNum
)
 
Key information
This method uses key number 5 (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
pBookBSTRAscendingCase insensitive
pDocNumLONG (unsigned)Ascending-
pIsOpenVARIANT_BOOLAscending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
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->SeekByOpenStatus (smFirst, "", 0);
while (pSOrder->GetDBStatus () == 0)
{
    // Process record data

    pSOrder->GetNext ();
}

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

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

    oSOrder.GetNext ();
}

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

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

    Call oSOrder.GetNext()
Wend

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

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

    oSOrder.GetNext()
End While

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