Forum Discussion

Olaf_A's avatar
Olaf_A
New Contributor III
26 days 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
26 days 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)