SQL Syntax Doesn't Work in Switch

Post Reply
rgpepper
Member
Posts: 73
Joined: Wed Oct 14, 2015 2:09 am

SQL Syntax Doesn't Work in Switch

Post by rgpepper » Wed May 06, 2020 9:22 pm

This syntax executes just fine in Excel against a FileMaker Pro 14 server, but from the Switch Database connect configurator, it hangs up FileMaker.
I had to modify the query from a version that worked fine, the main difference here is the use of the JOIN command, never used it before. Again, Excel runs this query just fine.

SELECT j.Stock_Covers, t.SeriesName, c.Name, j.ISBN, t.Title_Name, j.Bindery_Style, j.Trim_Pgs, j."Finished Size", j.Color, j.Color_Cover, j.Page_Count, j.Hagen_ID_Int, j.Hagen_ID_Cvr, j.Prinergy_Name_If_Not_ISBN
FROM Job j
INNER JOIN Title t ON t.ISBN = j.ISBN
JOIN Customer c ON c.CustID = j.CustID
WHERE j.ISBN = [Job.NameProper]
Last edited by rgpepper on Wed May 06, 2020 11:24 pm, edited 2 times in total.

rgpepper
Member
Posts: 73
Joined: Wed Oct 14, 2015 2:09 am

Re: SQL Syntax Doesn't Work in Switch

Post by rgpepper » Wed May 06, 2020 10:27 pm

Figured it out:
For these 2 lines:

INNER JOIN Title t ON t.ISBN = j.ISBN
JOIN Customer c ON c.CustID = j.CustID

I broke them apart to:

INNER JOIN Title t
ON t.ISBN = j.ISBN
JOIN Customer c
ON c.CustID = j.CustID

And it worked. But, again, the former version worked in Excel on Windows.

Post Reply