title: AdoQuery not working with SHOW: command
body: <p>and I am tearing my hair out!!</p>
  
  <p>Even something simple like this work:  </p>
  
  <pre><code>procedure MyAdoQueryTest();
     const MYSQL_CONNECT_STRING='Driver={MySQL ODBC 5.1 Driver};Server=%s;Port=3306;Database=%s;User=%s;Password=%s;Option=3;';
  
     var   AdoConnection  : TADOConnection;
           ADOQuery : TADOQuery;
           Param    : TParameter;
  begin
     AdoConnection := TADOConnection.Create(Nil);
     AdoConnection.ConnectionString := Format(MYSQL_CONNECT_STRING,['localhost',
                                                                    'mysql',
                                                                'root',
                                                                '']);
      AdoConnection.LoginPrompt := False;
      AdoConnection.Connected := True;
  
     ADOQuery := TADOQuery.Create(Nil);
     ADOQuery.Connection := AdoConnection;
     ADOQuery.Sql.Clear();
     ADOQuery.SQl.Add('SHOW :what_to_show');
  
     Param := ADOQuery.Parameters.ParamByName('what_to_show');
     Param.DataType := ftString;
     Param.Value := 'databases';
  
     ADOQuery.Prepared := true;
     ADOQuery.Active := True;
  end;
  </code></pre>
  
  <p>(btw, do I really need to use the 'Param' variable and 3 statements, or can I just ` ADOQuery.Parameters.ParamByName('what_to_show').Value := 'databases';?)</p>
  
  <p>Anyway, when I run it, I get an exception at <code>ADOQuery.SQl.Add('SHOW :what_to_show');</code> which says "Arguments are of the wrong type, are out of the acceptable range or are in conflict with one another".</p>
  
  <p>What I am trying to do is to make 2 central functions: one which will accept and execute any SQL statement which will not return any data (such as INSERT INTO) and oen which will (such as SELECT). </p>
  
  <p>I currently have these working with AdoConnection only, but am now trying to use AdoQuery because I want to parametrize my SQL statements to handle strings with quotes in them.</p>
  
  <p>I can has halpz?</p>