rsmellette

One SQL formula works, one doesn't

Discussion created by rsmellette on Sep 15, 2014
Latest reply on Sep 16, 2014 by BruceHerbach

I'm used to GUI SQL from Access, so writing it out is driving me nuts... but...

 

I managed to make this formula work:

 

ExecuteSQL ("SELECT SUM (TotalRunTime) FROM Films WHERE FeatureShort = ? AND Consider = ?" ; "" ; ""; "Feature"; "Competition";)

 

But when I try to add a new field restriction from the Films table, it doesn't.

 

ExecuteSQL ("SELECT SUM (TotalRunTime) FROM Films WHERE FeatureShort = ? AND Consider = ? AND Round = ?" ; "" ; ""; ""; "Feature"; "Competition";"In")

 

 

Any help?

Outcomes