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.

 

Mike

Outcomes