SAP Business One UI API 10.0 - Objects Reference (10.00.270)

• Query Method

  • UI API

  • • Description

      Runs the specified condition set query on the data source (table).

  • • Syntax

      Visual Basic
      Public Sub Query( _    Optional ByVal Conds As Conditions = 0 _ )

  • • Parameters

      Conds

      The condition for the query

  • • Remarks

      You cannot run this method on DBDataSource objects bounded to system forms.

  • • Example

      Querying a data source connected to a database table (Visual Basic)

      Public Sub QueryingDBDataSource()     Dim oForm As SAPbouiCOM.Form     Dim oDBDataSource As SAPbouiCOM.DBDataSource     '// Add a new form     Set oForm = SBO_Application.Forms.Add("SampleForm")     '// Add a DBDataSource to the Business Partners table     Set oDBDataSource = oForm.DataSources.DBDataSources.Add("OCRD")     '// Execute the query with the conditions collection    oDBDataSource.Query End Sub

  • • See Also

      DBDataSource Object