SInvceDet::SeekByRepres (Interface: SInvceDet)
 
Seeks a Sales Invoice Detail line by its representative.
 
VARIANT_BOOL SeekByRepres (
    enum eSeekMode eSeekMode,
    BSTR bsRepresentative,
    DATE dDocDate,
    BSTR bsBook,
    LONG lDocNum,
    SHORT sLineNum
)
 
Key information
This method uses key number 11 (See SwapKey).
This is a unique key.
 
Key segment information
Segment NameTypeOrderCollation
pRepresentativeBSTRAscendingCase insensitive
pDocDateDATE (date)Ascending-
pBookBSTRAscendingCase insensitive
pDocNumLONG (unsigned)Ascending-
pLineNumSHORT (unsigned)Ascending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
bsRepresentative
[in] The representative 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
CreateSInvceDet
GetDBStatus
GetNext
 
Samples
 
C++
 
// Seek the data of all detail lines of all sales invoices of representative 'REPRES'
CString strRepres = "REPRES";
pSInvceDet->SeekByRepres (smGreaterOrEqual, (LPCSTR)strRepres, COleDateTime (0, 0, 0, 0, 0, 0).m_dt, "", 0, 0);
while (pSInvceDet->GetDBStatus () == 0 && (CString)pSInvceDet->pRepresentative == strRepres)
{
    // Process record data
    
    pSInvceDet->GetNext ();
}

C#
 
// Seek the data of all detail lines of all sales invoice of representative 'REPRES'
string strRepres = "REPRES";
oSInvceDet.SeekByRepres (eSeekMode.smGreaterOrEqual, strRepres, new DateTime (), "", 0, 0);
while (oSInvceDet.GetDBStatus () == 0 && oSInvceDet.pRepresentative.ToString () == strRepres)
{
    // Process record data
    
    oSInvceDet.GetNext ();
}

VBS
 
' Seek the data of all detail lines of all sales invoice of representative 'REPRES'
Dim strRepres
Dim dtDocDate
strRepres = "REPRES"
Call oSInvceDet.SeekByRepres(smGreaterOrEqual, strRepres, dtDocDate, "", 0, 0)
While oSInvceDet.GetDBStatus() = 0 And oSInvceDet.pRepresentative = strRepres
    ' Process record data

    Call oSInvceDet.GetNext()
Wend

VB.NET
 
' Seek the data of all detail lines of all sales invoice of representative 'REPRES'
Dim strRepres As String
Dim dtDocDate As Date
strRepres = "REPRES"
oSInvceDet.SeekByRepres(eSeekMode.smGreaterOrEqual, strRepres, dtDocDate, "", 0, 0)
While oSInvceDet.GetDBStatus() = 0 And oSInvceDet.pRepresentative = strRepres
    ' Process record data

    oSInvceDet.GetNext()
End While