KB426559: Freeform SQL reports pass prompt value of ‘?’ after parameterized queries are turned off from an existing database connection in MicroStrategy 10.6 and up.

SYMPTOM:
 
In Strategy Developer 10.6 and 10.7, executing a report with a text prompt and having parameterized queries turned on for the database instance connection will return a "?" for the prompt value.  If the parameterized query option is at any point turned off, the text prompt values will still resolve with ‘?’.
 
STEPS TO REPRODUCE:
1.) Within Strategy Tutorial, create a new Freeform database instance with a new DB connection and turn on parameterized queries.
2.) Create FFSQL report with the following definition:
 

select * from table where column = [Value (Text)];

3.) Run report, notice “?” is display as designed for parameterized queries setting.
4.) Back in the database connection, turn off parameterized queries.  Notice that “?” is still passed for the prompt answer.
CAUSE:
 
This is identified as a known issue in Strategy 10.6 and 10.5.
 
ACTION:
 
This issue has been addressed in 10.7. Upgrade to this version to take advantage of this fix.
WORKAROUND:
Create a new database instance with a database connection that has parameterized queries turned off.
  KB426559