ADO reading parameters into SQL

Hi Chris,



After some investigations, I've found a workaround for you. You can execute an SQL query to your database by using another object, IAQAADOConnection, which is returned by the ADO.CreateADOConnection method. Please try using this object instead of IAQAADOQuery returned by ADO.CreateADOQuery in your test where you need to use the colon character enclosed into quotes. You can use something like the following example (it seems to work fine in my sample test):

  // Create an IAQAADOConnection object

  var connection = ADO.CreateADOConnection();

  

  // Specify the connection string

  connection.ConnectionString = getConnectionString();

  connection.LoginPrompt = false;

  

  // Specify the SQL query

  var sql = "select '\" : \"' as text from dual";

  

  connection.Open();

  

  // Execute the query and get a recordset

  var rs = connection.Execute_(sql);

  

  // Move through the received records and use their fields

  while (!rs.EOF)

  {

    Log.Message(rs.Fields.Item("name"), rs.Fields.Item("address"));

    rs.MoveNext();

  }

  

  connection.Close();

Does this workaround help in your case? Please let me know your results.