IFindProjectsWithLastCompletedSale Method |
Returns list of Projects with matching sale counters. Search by date.
Namespace:
SuperOffice.COM.SuperOfficeDB
Assembly:
SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
SyntaxSOProjects ProjectsWithLastCompletedSale(
EnSaleStatus Status,
IListTextItem amountclass,
EnFindOperator op,
DateTime Value
)
Function ProjectsWithLastCompletedSale (
Status As EnSaleStatus,
amountclass As IListTextItem,
op As EnFindOperator,
Value As DateTime
) As SOProjects
Dim instance As IFind
Dim Status As EnSaleStatus
Dim amountclass As IListTextItem
Dim op As EnFindOperator
Dim Value As DateTime
Dim returnValue As SOProjects
returnValue = instance.ProjectsWithLastCompletedSale(Status,
amountclass, op, Value)
SOProjects^ ProjectsWithLastCompletedSale(
[InAttribute] EnSaleStatus Status,
[InAttribute] IListTextItem^ amountclass,
[InAttribute] EnFindOperator op,
[InAttribute] DateTime Value
)
Parameters
- Status
- Type: SuperOffice.COM.SuperOfficeDBEnSaleStatus
- amountclass
- Type: SuperOffice.COM.SuperOfficeDBIListTextItem
The amountclass of the sales, NULL equals all amountclasses - op
- Type: SuperOffice.COM.SuperOfficeDBEnFindOperator
- Value
- Type: SystemDateTime
Date to use in comparison with the operator
Return Value
Type:
SOProjectsSOProjects - a collection of projects matching the query
ExamplesThis text may be copied to the notepad, and saved as a *.vbs file. Remember to change the login information.
Dim objSO
Dim myProjs
Dim myProj
enSaleAllCounters = 4
enFindOpLessThanOrEqual = 4
Set objSO = CreateObject("SuperOfficeDB.Database")
If not (objSO is nothing) Then
objSO.login "USERID", "PASSWORD"
Set myProjs = objSO.Find.ProjectsWithLastCompletedSale(enSaleAllCounters, Nothing, enFindOpLessThanOrEqual, #1/1/2007#)
Set myProj = myProjs.GetFirst
While Not myProjs.EOF
msg = msg & myProj.Name & vbCrLf
Set myProj = myProjs.GetNext
Wend
If msg <> "" Then
MsgBox msg, vbInformation & vbOKOnly, "Projects matching search"
Else
MsgBox "No match"
End If
Else
MsgBox "Could not log in"
End If
Set objSO = Nothing
See Also