[Klaus79]

5 years ago #17968

in my SQL connector I would like to return the executed SQL statement to calling business object for log purposes,

e.g.:

Parameter ‘request’: INSERT INTO tutyp (customer_id, langu, usertyp, utyptext, utyplongtext) VALUES (:CustID:, :langu:, :usertyp:, :utyptext:, :utyplongtext:);

returned parameter ‘statement’:INSERT INTO tutyp (customer_id, langu, usertyp, utyptext, utyplongtext) VALUES (1, ‘D’:, 01, ‘Operational’, ‘Operationaler User’);

 

Is this possible?

[Kahn Has successfully completed the online course IntroductionHas successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)]

5 years ago #17969

Up

0

Down

::

The full unresolved statement can be found in the Execution Log (INFO). The provided parameters are also provided. A resolved statement is not logged.

 

Cheers

[Klaus79]

5 years ago #17971

Up

0

Down

::

I need it for my own application log.

That means I have to read info log after execution of sql statement?

But how do I get the right corresponding one?