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' OkElse' ErrorEnd IfEnd With