|
Seeks a Sales Invoice Detail line by its classification. |
|
|
VARIANT_BOOL SeekByClass ( enum eSeekMode eSeekMode, BSTR bsClassification, DATE dDocDate, BSTR bsBook, LONG lDocNum, SHORT sLineNum ) |
|
|
Key information | | This method uses key number 6 (See SwapKey). | | This is a unique key. |
| | Key segment information | Segment Name | Type | Order | Collation | pClass | BSTR | Ascending | Case insensitive | pDocDate | DATE (date) | Ascending | - | pBook | BSTR | Ascending | Case insensitive | pDocNum | LONG (unsigned) | Ascending | - | pLineNum | SHORT (unsigned) | Ascending | - |
| | Parameters | eSeekMode | [in] A value of the 'eSeekMode' enumeration. | bsClassification | [in] The classification of the Sales Invoice of which you want to seek a detail line. | dDocDate | [in] The document date of the Sales Invoice of which you want to seek a detail line. | bsBook | [in] The book code of the Sales Invoice of which you want to seek a detail line. | lDocNum | [in] The document number of the Sales Invoice of which you want to seek a detail line. | sLineNum | [in] The line number of the Sales Invoice 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 of all sales invoices with a classification code of 'CLASS'
CString strClass = "CLASS";
pSInvceDet->SeekByClass (smGreaterOrEqual, (LPCSTR)strClass, COleDateTime (0, 0, 0, 0, 0, 0).m_dt, "", 0, 0);
while (pSInvceDet->GetDBStatus () == 0 && (CString)pSInvceDet->pClass == strClass)
{
// Process record data
pSInvceDet->GetNext ();
}
|
|
|
C# |
|
// Seek the data of all detail lines of all sales invoices with a classification code of 'CLASS'
string strClass = "CLASS";
oSInvceDet.SeekByClass (eSeekMode.smGreaterOrEqual, strClass, new DateTime (), "", 0, 0);
while (oSInvceDet.GetDBStatus () == 0 && oSInvceDet.pClass.ToString () == strClass)
{
// Process record data
oSInvceDet.GetNext ();
}
|
|
|
VBS |
|
' Seek the data of all detail lines of all sales invoices with a classification code of 'CLASS'
Dim strClass
Dim dtDocDate
strClass = "CLASS"
Call oSInvceDet.SeekByClass(smGreaterOrEqual, strClass, dtDocDate, "", 0, 0)
While oSInvceDet.GetDBStatus() = 0 And oSInvceDet.pClass = strClass
' Process record data
Call oSInvceDet.GetNext()
Wend
|
|
|
VB.NET |
|
' Seek the data of all detail lines of all sales invoices with a classification code of 'CLASS'
Dim strClass As String
Dim dtDocDate As Date
strClass = "CLASS"
oSInvceDet.SeekByClass(eSeekMode.smGreaterOrEqual, strClass, dtDocDate, "", 0, 0)
While oSInvceDet.GetDBStatus() = 0 And oSInvceDet.pClass = strClass
' Process record data
oSInvceDet.GetNext()
End While
|
|