| |
| Seeks an unpaid Sales Delivery Detail line by its article and customer number. |
| |
 |
VARIANT_BOOL SeekByUnpaidArtCst (
enum eSeekMode eSeekMode,
BSTR bsArtNum,
LONG lCstNum,
LONG lCstSubNum,
BSTR bsBook,
LONG lDocNum,
SHORT sLineNum
) |
|
| |
| Key information |  | This method uses key number 9 (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 | | pArtNum | BSTR | Ascending | Hierarchy | | pCstNum | LONG (unsigned) | Ascending | - | | pCstSubNum | LONG (unsigned) | Ascending | - | | pBook | BSTR | Ascending | Case insensitive | | pDocNum | LONG (unsigned) | Ascending | - | | pLineNum | SHORT (unsigned) | Ascending | - | | pIsOpen | VARIANT_BOOL | Ascending | - |
| | | | Parameters | | eSeekMode | | [in] A value of the 'eSeekMode' enumeration. | | bsArtNum | | [in] The article number of the Sales Delivery Detail line you want to seek. | | lCstNum | | [in] The customer number of the Sales Delivery of which you want to seek a detail line. | | lCstSubNum | | [in] The customer subnumber of the Sales Delivery of which you want to seek a detail line. | | bsBook | | [in] The book code of the Sales Delivery of which you want to seek a detail line. | | lDocNum | | [in] The document number of the Sales Delivery of which you want to seek a detail line. | | sLineNum | | [in] The line number of the Sales Delivery Detail line you want to seek. |
| |
Remarks
|
|
This number is a 0-based index, i.e. it starts from 0. Therefore the value of this parameter is 1 less than the numbers shown in the Venice grids and 1 less than the value returned by the property vLine (see properties)! |
|
| | | Return value |
| True if the record with the given properties was found, otherwise false. |
| |
| See Also |
|
|
|
| |
| Samples |
| |
|
C++ |
| |
// Seek the data of all detail lines for the article with number = 'Art_001' of all unpaid sales deliveries for the custom with number 25
CString strArtNum = "Art_001";
long lCstNum = 25, lSubNum = 0;
pSDelivDet->SeekByUnpaidArtCst (smGreaterOrEqual, (LPCSTR)strArtNum, lCstNum, lSubNum, "", 0, 0);
while (pSDelivDet->GetDBStatus () == 0 && (CString)pSDelivDet->pArtNum == strArtNum && (long)pSDelivDet->pCstNum == lCstNum && (long)pSDelivDet->pCstSubNum == lSubNum)
{
// Process record data
pSDelivDet->GetNext ();
}
|
|
|
C# |
| |
// Seek the data of all detail lines for the article with number = 'Art_001' of all unpaid sales deliveries for the custom with number 25
string strArtNum = "Art_001";
int iCstNum = 25, iSubNum = 0;
oSDelivDet.SeekByUnpaidArtCst (eSeekMode.smGreaterOrEqual, strArtNum, iCstNum, iSubNum, "", 0, 0);
while (oSDelivDet.GetDBStatus () == 0 && oSDelivDet.pArtNum.ToString () == strArtNum && (int)oSDelivDet.pCstNum == iCstNum && (int)oSDelivDet.pCstSubNum == iSubNum)
{
// Process record data
oSDelivDet.GetNext ();
}
|
|
|
VBS |
| |
' Seek the data of all detail lines for the article with number = 'Art_001' of all unpaid sales deliveries for the custom with number 25
Dim strArtNum, iCstNum, iSubNum
strArtNum = "Art_001"
iCstNum = 25
iSubNum = 0
Call oSDelivDet.SeekByUnpaidArtCst(smGreaterOrEqual, strArtNum, iCstNum, iSubNum, "", 0, 0)
While oSDelivDet.GetDBStatus() = 0 And oSDelivDet.pArtNum = strArtNum And oSDelivDet.pCstNum = iCstNum And oSDelivDet.pCstSubNum = iSubNum
' Process record data
Call oSDelivDet.GetNext()
Wend
|
|
|
VB.NET |
| |
' Seek the data of all detail lines for the article with number = 'Art_001' of all unpaid sales deliveries for the custom with number 25
Dim strArtNum As String
Dim iCstNum, iSubNum As Integer
strArtNum = "Art_001"
iCstNum = 25
iSubNum = 0
oSDelivDet.SeekByUnpaidArtCst(eSeekMode.smGreaterOrEqual, strArtNum, iCstNum, iSubNum, "", 0, 0)
While oSDelivDet.GetDBStatus() = 0 And oSDelivDet.pArtNum = strArtNum And oSDelivDet.pCstNum = iCstNum And oSDelivDet.pCstSubNum = iSubNum
' Process record data
oSDelivDet.GetNext()
End While
|
|
