Venice
ProjectDet::SeekByFirm
 
Seeks a Project Detail by its firm.
 
VARIANT_BOOL SeekByFirm (
    enum eSeekMode eSeekMode,
    enum eFirmType eFirmType,
    LONG lFrmNum,
    LONG lFrmSubNum,
    LONG lProject,
    SHORT sSeqNum
)
 
Key information
This method uses key number 3 (See SwapKey).
This is a unique key.
 
Key segment information
Segment NameTypeOrderCollation
pFrmTypeBYTEAscending-
pFrmNumLONG (unsigned)Ascending-
pFrmSubNumLONG (unsigned)Ascending-
pProjectLONG (unsigned)Ascending-
pSeqNumSHORT (unsigned)Ascending-
 
Parameters
eSeekMode
[in] A value of the 'eSeekMode' enumeration.
eFirmType
[in] A value of the 'eFirmType' enumeration.
lFrmNum
[in] The firm number of the project detail you want to seek.
lFrmSubNum
[in] The firm subnumber of the project detail you want to seek.
lProject
[in] The number of the project of which you want to seek a detail.
sSeqNum
[in] The sequence number of the project detail you want to seek.
 
See Also
CreateProjectDet
 
Samples
 
C++
 
// Seek all project details assigned to the customer with number 12/0
long lFrmNum = 12, lFrmSubNum = 0;
eFirmType eFT = ftCustomer;
pProjectDet->SeekByFirm (smGreater, eFT, lFrmNum, lFrmSubNum, 0, 0);
while (pProjectDet->GetDBStatus () == 0 && pProjectDet->pFrmType.bVal == eFT && (long)pProjectDet->pFrmNum == lFrmNum && (long)pProjectDet->pFrmSubNum == lFrmSubNum)
{
    // Process record data
    
    pProjectDet->GetNext ();
}

C#
 
// Seek all project details assigned to the customer with number 12/0
int iFrmNum = 12, iFrmSubNum = 0;
eFirmType eFT = eFirmType.ftCustomer;
oProjectDet.SeekByFirm (eSeekMode.smGreater, eFT, iFrmNum, iFrmSubNum, 0, 0);
while (oProjectDet.GetDBStatus () == 0 && (eFirmType)Enum.ToObject(typeof(eFirmType), oProjectDet.pFrmType) == eFT && (int)oProjectDet.pFrmNum == iFrmNum && (int)oProjectDet.pFrmSubNum == iFrmSubNum)
{
    // Process record data
    
    oProjectDet.GetNext ();
}

VBS
 
' Seek all project details assigned to the customer with number 12/0
Dim dwFrmNum, dwFrmSubNum
Dim eFT
dwFrmNum = 12
dwFrmSubNum = 0
eFT = ftCustomer
Call oProjectDet.SeekByFirm(smGreater, eFT, dwFrmNum, dwFrmSubNum, 0, 0)
While oProjectDet.GetDBStatus() = 0 And oProjectDet.pFrmType = eFT And oProjectDet.pFrmNum = dwFrmNum And oProjectDet.pFrmSubNum = dwFrmSubNum
    ' Process record data

    Call oProjectDet.GetNext()
Wend

VB.NET
 
' Seek all project details assigned to the customer with number 12/0
Dim ulFrmNum, ulFrmSubNum As ULong
Dim eFT As eFirmType
ulFrmNum = 12
ulFrmSubNum = 0
eFT = eFirmType.ftCustomer
oProjectDet.SeekByFirm(eSeekMode.smGreater, eFT, ulFrmNum, ulFrmSubNum, 0, 0)
While oProjectDet.GetDBStatus() = 0 And oProjectDet.pFrmType = eFT And oProjectDet.pFrmNum = ulFrmNum And oProjectDet.pFrmSubNum = ulFrmSubNum
    ' Process record data

    oProjectDet.GetNext()
End While