Concatenate string to query in axapta with external database connection

      Sql1 = "select * from TestTable WHERE Column1='"; 
        sql1 = sql1 + Column1 + "'"; 
        sql1 = sql1 + " and convert(datetime,DateColumn1) = ' "; 
        sql1 = sql1 + date2str(DateColumn1,321,2,3,2,3,4) + "'" ; 
        sql1 = sql1 + " and status=1 order by Column1,DateColumn1"; 
        command1 = new CCADOCommand(); 
        command1.activeConnection(connection); 
        command1.commandText(sql1); 
       recordSet1 = new CCADORecordSet(); 
       recordSet1 = command1.execute(); 
       Coms1 = recordSet1.recordSet();  
      while (!recordSet1.EOF()) 
       { 
           fields1 = recordSet1.fields(); 
           info(strfmt("%1",fields1.itemname("Columnname").value())); 
       }