Condition Object
See Also Members Example

Description

Represents an SQL condition (Where statement), for use with ChooseFromList and DBDataSource objects.

Example

Querying DBDataSource using conditions (Visual Basic) Copy Code

Public Sub QueryWithConditions()



    Dim oForm As SAPbouiCOM.Form

    Dim oDBDataSource As SAPbouiCOM.DBDataSource

    Dim oConditions As SAPbouiCOM.Conditions

    Dim oCondition As SAPbouiCOM.Condition



    '// Add new form

    Set oForm = SBO_Application.Forms.Add("SampleForm")



    '// Add a DBDataSource for Bussines Partners table

    Set oDBDataSource = oForm.DataSources.DBDataSources.Add("OCRD")



    '// Create conditions collection

    Set oConditions = SBO_Application.CreateObject(cot_Conditions)



    '// Let's assume we wish our query to select

    '// Business Partners of type "C" (Customers)

    '// or "S" (Suppliers)



    '// WHERE ((CardType = 'C') Or (CardType = 'S'))



    '// the conditions collection encapsulates the WHERE clause

    '// of a SELECT statement



    Set oCondition = oConditions.Add

    '// ((CardType = 'C') Or

    oCondition.BracketOpenNum = 2

    oCondition.Alias = "CardType"

    oCondition.Operation = co_EQUAL

    oCondition.CondVal = "C"

    oCondition.BracketCloseNum = 1

    oCondition.Relationship = cr_OR



    Set oCondition = oConditions.Add

    '// (CardType = 'S'))

    oCondition.BracketOpenNum = 1

    oCondition.Alias = "CardType"

    oCondition.Operation = co_EQUAL

    oCondition.CondVal = "S"

    oCondition.BracketCloseNum = 2



   '// Execute the query with the conditions collection



   oDBDataSource.Query oConditions



End Sub

Example

Description

Example

Example

See Also