CODEWITHSUNDEEP
delphidelphi-xe
Lucas Medeiros
Lucas Medeiros

Reputation: 85

Trace with TSQLMonitor don't works

I'm trying to use the TSQLMonitor component, but I have no success...

I have the follow code in my OnTrace event:

procedure TForm1.SQLMonitor1LogTrace(Sender: TObject; TraceInfo: TDBXTraceInfo);
begin
  memo1.Lines.Add(traceinfo.message);
end;

Works as well, but "my" values in the SQL command are represented by question symbol ("?"), and I don't no why! Look an example:

INTERBASE - isc_start_transaction
INTERBASE - isc_dsql_allocate_statement
**update "CDSUBPRODUTOS"  set
 "DATAINCLUSAO" = ?
where
 "CDSPRCODIGO" = ? and
 "DATAINCLUSAO" = ? and
 "DATAALTERACAO" is null and
 "CODUSUARIOALTERACAO" = ? and
 "CDSPRCODGRUPO" = ? and
 "CDSPRSITUACAO" = ? and
 "CDSPRDESCRICAO" = ? and
 "CDSPRMEDIDA" = ? and
 "CDSPRVALOR" = ? and
 "CDSPRUTILIZARFORMACAOPRECO_SN" = ?**

INTERBASE - isc_dsql_prepare
INTERBASE - isc_dsql_sql_info
INTERBASE - isc_portable_integer
INTERBASE - isc_dsql_describe_bind
INTERBASE - SQLDialect = 3
INTERBASE - isc_dsql_execute
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_commit_transaction

I would likke that these symbols were replaced with the correct values ​​(in this case, the changed values​​). I'm using Delphi XE with Firebird 2.5.

If someone could help me, I'll appreciate!!! Hugs!

Upvotes: 3

Views: 586

Answers (1)

Jan Doggen
Jan Doggen

Reputation: 9096

From searching around on the internet it appears that TSQLMonitor does not show the parameter values. There's even a 2002 Quality Central issue #1358 asking for parameter support. I could not find any setting or property either.

Upvotes: 2

Related Questions