| |
| 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 Name | Type | Order | Collation | | pCstNum | LONG (unsigned) | Ascending | - | | pBook | BSTR | Ascending | Case insensitive | | pDocNum | LONG (unsigned) | Ascending | - | | pIsOpen | VARIANT_BOOL | Ascending | - |
| | | | 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 |
|
|
|
| |
| 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
|
|
