Article Details

Id:	12394
Product:	finPOWER Connect
Type:	NEW
Version:	2.02.03
Opened:	11/11/2014
Closed:	11/11/2014
Released:	04/12/2014
Job:	J014468

ISSelectQueryBuilder; New method to append an "IN" using a sub-query builder

The business layer ISSelectQueryBuilder object has been updated to better support creating queries using an "IN" with a sub-query.

The following code sample demonstrates how to use the new AppendInSubQuery method:

Dim dt As DataTable
Dim sqb As ISSelectQueryBuilder
Dim sqbSub As ISSelectQueryBuilder

sqb = finBL.Database.CreateSelectQueryBuilder()
sqbSub = finBL.Database.CreateSelectQueryBuilder()

With sqbSub
	.Table = "Account"
	.Fields.AddList("AccountId")
	.SqlWhere.AppendComparisonString("AccountId", "Like", "RC%")
End With

With sqb
	.Table = "Account"
	.Fields.AddList("AccountId,Name")
	.SqlWhere.AppendInSubQuery("AccountId", sqbSub)
	.OrderByFields.Add("AccountId")
End With

If sqb.ExecuteDataTable(dt) Then
	mUI.CommonForms.ShowDataSetViewerFromDataTable(dt)
Else
	mUI.ErrorMessageShow()
End If

Print this Article