2 Replies Latest reply on Nov 3, 2013 6:07 PM by user28097

    Failure to sort...

    user28097

      This looks simple -- I am selecting to sort records on a text field that contains either "T" or "F". But the sort option does nothing. The records remain in their original sort order with T's and F's in no particular order. I can sort the same records by another text field (last name) and that works.

       

      This table was imported from a FoxPro table where the field type was a "logical" field which means it contained a logical true or false. Apparently FileMaker converts these to text and uses the letters "T" and "F" instead. Not sure if that's related.

       

      Any reason that sorting on a particular field would have no effect?

        • 1. Re: Failure to sort...
          PeterWindle

          You may want to check the field "type", if it's set as a number instead of text, this may explain the behavior.

          I would even try creating a new calculation field (resulting in a number) that gives a 1 if the field is "T" else, 0. Then sort on the calc field to see what happens.

          • 2. Re: Failure to sort...
            user28097

            You are correct. The type is number. So when FileMaker imports FoxPro logical fields, it creates them as numeric fields, but the value imported is either "T" or "F". This is confusing. Do you know if this is documented anywhere?  If not, I guess I'll need to experiment.

             

            I already had a calculated field based on this field which would display a checkmark (option-V) when the value is "T" [If (Prepared = "T"; "√"; "" )] and that is working.

             

            Thanks for pointing me to the field type.