IndexFieldNames issue

[MarkF]

I'm using version 8.6.12. It appears that something has changed with IndexFieldNames such that double quotes are no longer allowed in the column name. This causes a problem if the column name includes a space. Our original code looks like:

Code: Select all

      FldName := FDataSet.FieldDefs[ADataCol].DisplayName;
      FldName := AnsiQuotedStr(FldName, '"');   // No longer allowed?
      case ASortDir of
        sdAsc:  SortString := FldName + ' ASC  CIS';
        sdDesc: SortString := FldName + ' DESC CIS';
      end;
      FDataSet.IndexFieldNames := SortString;

-Mark Ford
Benthic Software

[MarkF]

In looking at the source code, it appears that instead of using doublequotes, we can use square brackets. This seems to work even if a field's displayname contains a space, however it fails if the field's displayname contains a square bracket. It seems like allowing double quotes as the field name delimiter in IndexFieldNames is a better choice. It would be interesting to know why this was changed.

-Mark Ford
Benthic Software

[AlexP]

Hello,

Thank you for the information, we have already fixed the problem with quoting, this fix will be added to next version, that will be released this month.