NEW3.02.00 · Released 15 August 2019
NEWfinPOWER Connect
Released in
3.02.00
15 August 2019
- Opened5 Apr
- Closed17 May
- 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' OkElse' ErrorEnd IfEnd With