boyd1988

SQL "There is an error in the syntax of the query." On all query's

Discussion created by boyd1988 on Oct 26, 2018
Latest reply on Oct 26, 2018 by beverly

Hi All,

 

When I do a ExecuteSQL () I am getting "There is an error in the syntax of the query." with in the data viewer.

 

but when I attempt to change the Expression with in the data viewer Filemaker crashes.

 

ExecuteSQL ( "SELECT d__NameLast FROM @User WHERE d__NameFirst = ?" ; "" ; "" ; @User::d__NameFirst )

 

OS: macOS Mojave (10.14)

Filemaker: 17.0.2.205

Outcomes