As of Daylite 3.9, one gotcha that involves qualifier queries from f-script is that the qualifier ‘isLike’ no longer works if you pass it a numerical value. OpenBase handled this behind the scense, but Postgres will error out on it. So, for example, I used to do something like

aContactID := 1200.
myQualifier := BDQualifier qualifierWhereValueOfKey:’contactID’ isLike:aContactID.

And this would work. This will not work from 3.9 forward however. To match numerical values, the following would be used:

myQualifier := BDQualifier qualifierWhereValueOfKey:’contactID’ isEqualTo:aContactID.

This also means that the ‘qual2′ example on page 135 needs to be corrected in order to work. Off to put this on the errata page!