NEW3.02.00 · Released 15 August 2019
NEWfinPOWER Connect
Released in
3.02.00
15 August 2019
  1. Opened5 Apr
  2. Closed17 May
  3. Released15 Aug
Article 16104 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