ExecuteSQL() problem

[doughemi]

When I create a calculation field with the following ExecuteSQL function, it works fine:

 

ExecuteSQL ( 

"SELECT  DISTINCT "Regatta Contact AMYAnum"

FROM "Regatta Schedule"

WHERE OnLineReg = ?

 ";

"" ; "¶"; 1)

 

But when I add a further qualifier 

 

ExecuteSQL ( 

"SELECT  DISTINCT "Regatta Contact AMYAnum"

FROM "Regatta Schedule"

WHERE OnLineReg = ?

and Date > CURRENT_DATE()

 ";

"" ; "¶"; 1)

 

It returns the dreaded "?".

 

What is the correct syntax?

[Lee Smith]

Automatic message

This topic has been moved from "Calculation Engine (Define Fields)" to "FQL or FileMaker Query Language".

[volkovpunk]

ExecuteSQL ( 

"SELECT  DISTINCT "Regatta Contact AMYAnum"

FROM "Regatta Schedule"

WHERE OnLineReg = ?

and "Date" > ?

 ";

"" ; "¶"; 1; Get(CurrentDate))

[doughemi]

Thanks.  I think I tried every permutation of delimited quotes and question marks besides that one.

[volkovpunk]

And be careful: in sql statement you should surely quote field names like Date, Order (as they are reserved words)