PInvceDet::SeekByFupCode (Interface: PInvceDet)
 
Seeks a Purchase Invoice Detail line by its follow-up code.
 
VARIANT_BOOL SeekByFupCode (
    enum eSeekMode eSeekMode,
    BSTR bsFupCode,
    DATE dDocDate,
    BSTR bsBook,
    LONG lDocNum,
    SHORT sLineNum
)
 
Key information
This method uses key number 13 (See SwapKey).
This is a unique key.
This is a null key, only the records where pFollowUp is not blank are in the index.
 
Key segment information
Segment NameTypeOrderCollation
pFollowUpBSTRAscendingCase insensitive
pDocDateDATE (date)Ascending-
pBookBSTRAscendingCase insensitive
pDocNumLONG (unsigned)Ascending-
pLineNumSHORT (unsigned)Ascending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
bsFupCode
[in] The follow-up code of the Purchase Invoice Detail line you want to seek.
dDocDate
[in] The document date of the Purchase Invoice of which you want to seek a detail line.
bsBook
[in] The book code of the Purchase Invoice of which you want to seek a detail line.
lDocNum
[in] The document number of the Purchase Invoice of which you want to seek a detail line.
sLineNum
[in] The line number of the Purchase 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
CreatePInvceDet
GetDBStatus
GetNext
 
Samples
 
C++
 
// Seek the data of all detail lines with a follow-up code of 'FUP' of all purchase invoices
CString strFupCode = "FUP";
pPInvceDet->SeekByFupCode (smGreaterOrEqual, (LPCSTR)strFupCode, COleDateTime (0, 0, 0, 0, 0, 0).m_dt, "", 0, 0);
while (pPInvceDet->GetDBStatus () == 0 && (CString)pPInvceDet->pFollowUp == strFupCode)
{
    // Process record data
    
    pPInvceDet->GetNext ();
}

C#
 
// Seek the data of all detail lines with a follow-up code of 'FUP' of all purchase invoices
string strFupCode = "FUP";
oPInvceDet.SeekByFupCode (eSeekMode.smGreaterOrEqual, strFupCode, new DateTime (), "", 0, 0);
while (oPInvceDet.GetDBStatus () == 0 && oPInvceDet.pFollowUp.ToString () == strFupCode)
{
    // Process record data
    
    oPInvceDet.GetNext ();
}

VBS
 
' Seek the data of all detail lines with a follow-up code of 'FUP' of all purchase invoices
Dim strFupCode
Dim dtDocDate
strFupCode = "FUP"
Call oPInvceDet.SeekByFupCode(smGreaterOrEqual, strFupCode, dtDocDate, "", 0, 0)
While oPInvceDet.GetDBStatus() = 0 And oPInvceDet.pFollowUp = strFupCode
    ' Process record data

    Call oPInvceDet.GetNext()
Wend

VB.NET
 
' Seek the data of all detail lines with a follow-up code of 'FUP' of all purchase invoices
Dim strFupCode As String
Dim dtDocDate As Date
strFupCode = "FUP"
oPInvceDet.SeekByFupCode(eSeekMode.smGreaterOrEqual, strFupCode, dtDocDate, "", 0, 0)
While oPInvceDet.GetDBStatus() = 0 And oPInvceDet.pFollowUp = strFupCode
    ' Process record data

    oPInvceDet.GetNext()
End While