Forum Discussion

Olaf_A's avatar
Olaf_A
New Contributor III
2 months ago

Multiple DbWhere statement

Hi, Does anyone have an example where multiple dbwheres on the same column are executed? The syntax seems to support AND/OR, but I can't seem to get it working.  I have the following dbWher...
Extenders
MarcR's avatar
MarcR
VIP
2 months ago

Hi Olaf, you can create a list of dbwheres land add that to your query:

Dim dbWheres As New List (Of DbWhere)
	dbwheres.Add(New DbWhere("Year", "=",dYEar))
	dbwheres.Add(New DbWhere("Sub", "=",Entity))
	dbwheres.Add(New DbWhere(PeriodValue, "=","1"))
Dim Holding As String = BRApi.Database.LookupRowFieldValue(si, "App", "OwnerShipTable", dbWheres, "Holding", String.Empty)