Strange FMP result to SQL request

[mortemar]

Hi there !

I found something very disturbing while trying to access my data through an SQL request.

The request was built the following ways :

Select * FROM Formation WHERE (status = 'student' and university = 'Oxford' and grade = 'first')

or

Select * FROM Formation WHERE ((status = 'student') and (university = 'Oxford') and (grade = 'first'))

even

Select * FROM Formation WHERE (status = 'student') and (university = 'Oxford') and grade = ('first')

Everytime, FileMaker just did a search based on the last part of the where request (for instance here : grade = 'first'), the results did come right, based on the status and university field also, but everytime I took a look in FMP the search always happened on the last field.

This is quite a problem to me, as when retrieving over 500 records, the ODBC driver takes a long time to bring back the result set.

Most of the time, the SQL request shouldn't generate more than 50 records found in FMP, but I always have numbers according to the search on only one of my select field.

Anyone ever had this problem before ?

Is my SQL request bad ?

Thx in advance,

Jerry