AnsweredAssumed Answered

ExecuteSQL and "?"

Question asked by Mike_Mitchell Expert on Aug 8, 2012
Latest reply on Aug 23, 2012 by Mike_Mitchell

Okay, I'm definitely not a SQL whiz, and I do not get the use of the "?" in the SQL statements. Can somebody explain this to me? For example:


SELECT * FROM table WHERE table.DateField <= ?


I can't find this anywhere except as a single character wildcard. How does that work when you're querying a date field?


Or what about this one?


ExecuteSQL (

"SELECT * FROM table WHERE table.field IN (?,?,?)" ; " " ; "|" ; "(A,B,C)" ) (I think I got that syntax right)


What the heck is that?


'Splain to the dummy, please.