NEW2.02.03 · Released 4 December 2014
NEWfinPOWER Connect
Released in
2.02.03
4 December 2014
  1. Opened11 Nov
  2. Closed11 Nov
  3. Released4 Dec
Article 12394 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