Article Details

Id:	16104
Product:	finPOWER Connect
Type:	NEW
Version:	3.02.00
Opened:	05/04/2019
Closed:	17/05/2019
Released:	15/08/2019
Job:	J022148

ISSelectQueryBuilder.GroupByFields; now has an AddOtherUnescaped method

The business layer ISSelectQueryBuilder object's GroupByFields collection now has an AddOtherUnescaped method.

This can be used to allow provider-specific functions, e.g., with MS Access:

sqb = finBL.Database.CreateSelectQueryBuilder()
With sqb
  .Table = "Account"
  .Fields.AddOtherUnescaped("RTrim(Region)")
  .GroupByFields.AddOtherUnescaped("RTrim(Region)")

  If .ExecuteDataTable(dt) Then
    ' Ok
  Else
    ' Error
  End If
End With

Print this Article