ESS / SQL Query Structure

[undersea]

Has anyone run across FMP/FMS creating odd SQL Select statements when using ESS via FMS?

Here's a quick version of what I'm doing:

Filemaker Server 9.0.3.325 (Windows Server 2003)

System DNS created using default SQL driver

Filemaker Advanced 9.0v3 (Windows XP)

I'm trying to use invoice number in both tables to match and create a relationship. The relationship works, but is very slow and the SQL statements are not as simple as they could be.

Simple SQL Example:

SELECT Field001, Field002, InvoiceNo

FROM [sql_Table]

WHERE (InvoiceNo = '12345678')

Here's what FM is creating:

SELECT Field001,InvoiceNo,Field002

FROM [sql_Table]

WHERE (Field001=N'ABCD123' AND Field002=1 AND InvoiceNo=N'12345678')

What's strange is Field001 and Field002 aren't references anywhere in the FMP shadow table or the relationship.

One thing I can say is Field001 & Field002 are "Key" fields in the SQL table.

I called FMP tech support and was told I cannot edit the SQL statement when using ESS and a server based DSN.

I'm hoping someone else has run across this and maybe has another angle on it.

Any input would be very helpful.

Thanks,

Jon