mySqlMonitor - Not visible parameters

mySqlMonitor - Not visible parameters

Postby rafael_moreno » Tue 15 Aug 2006 17:50

Good afternoon,

mySqlMonitor not visible parameters in event TraceEvent. I am need for developer aplication log.

Exemplo

mySqlConnection1.Open();
try
{
MySqlCommand objMySqlCommand = mySqlConnection1.CreateCommand();
objMySqlCommand.CommandText = "INSERT INTO Cargo(CarCodigoEmpresa, CarDescricao) VALUES (:ACarCodigoEmpresa, :ACarDescricao)";
objMySqlCommand.Parameters.Clear();
objMySqlCommand.Parameters.Add("ACarDescricao", MySqlType.VarChar).Value = "Teste de Cargo";
objMySqlCommand.Parameters.Add("ACarCodigoEmpresa", MySqlType.VarChar).Value = "1";
objMySqlCommand.ExecuteNonQuery();
}
finally
{
mySqlConnection1.Close();
}

In the event TraceEvent not visible parameters.

Thank.

Ass.: Rafael
rafael_moreno
 
Posts: 1
Joined: Tue 15 Aug 2006 17:46

Postby Alexey » Wed 16 Aug 2006 09:20

Please specify what is meant by
mySqlMonitor not visible parameters in event TraceEvent

and by
In the event TraceEvent not visible parameters.

Unfortunately we were unable to translate this successfully.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Guest » Wed 16 Aug 2006 11:38

How to visualize the parameter in instruction SQL in the MySQLMonitor?
Guest
 

Postby Alexey » Wed 16 Aug 2006 13:14

Please describe what exactly you need or what is the problem.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby KW » Mon 26 May 2008 20:16

Alexey wrote:Please describe what exactly you need or what is the problem.


I am also wondering if it is possible to view the parameters. Basically, the MysqlMonitor only shows output such as:

Code: Select all
Execute: UPDATE `newschema`.`dept` SET `DNAME` = :p1 WHERE ((`DEPTNO` = :p2) AND ((:p3 = 1 AND `DNAME` IS NULL) OR (`DNAME` = :p4)) AND ((:p5 = 1 AND `LOC` IS NULL) OR (`LOC` = :p6)))


However, is it possible to view the parameters? What IS p1? What IS p2? Not very helpful knowing the placeholders and not the actual inputted parameters when debugging a sql statement. If I could view the paramters that would be extremely useful.
KW
 
Posts: 115
Joined: Tue 19 Feb 2008 19:12

Postby Alexey.mdr » Tue 27 May 2008 06:35

You have got two options:
1) Listen for the TraceEvent event and when it occurs cast the sender to the MySqlCommand. Then iterate on the parameters collection.
2) You can use DBMonitor tool. Note, the tool works with MyDirect .NET Pro edition only.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby KW » Tue 27 May 2008 18:10

Alexey.mdr wrote:You have got two options:
1) Listen for the TraceEvent event and when it occurs cast the sender to the MySqlCommand. Then iterate on the parameters collection.
2) You can use DBMonitor tool. Note, the tool works with MyDirect .NET Pro edition only.


Perfect thanks.
KW
 
Posts: 115
Joined: Tue 19 Feb 2008 19:12


Return to dotConnect for MySQL