AnsweredAssumed Answered

ExecuteSQL code works on offline backup, but fails on the Cloud files?

Question asked by beastblittle2 on Nov 20, 2018
Latest reply on Dec 7, 2018 by wimdecorte


About a month ago, I spent about a week figuring out how to get an SQL code to return all Store Codes associated with one Customer Number with no repeats. Below is the code that currently works on my offline backup.

 

ExecuteSQL (

 

"SELECT DISTINCT a.\"Store Code\"

 

FROM \"Ad Archives\" a

 

WHERE \"Customer #\" = ?" ;

 

"    " ; "," ;

 

Customer #

 

)

Fairly simple and straightforward (Now that I understand SQL a bit better!) However, when I move this SQL code over to my Cloud files, it simply outputs a "?". I made sure that the Store Code field is there and names properly, same with the Customer Number field and the Ad Archives table. What else could possibly be causing this issue that I'm not seeing?

Outcomes