sql connector: returning request parameter

Tagged:
  • Klaus79
    Participant
      5 years, 11 months 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
      Moderator
        Has successfully completed the online course Introduction
        Has successfully completed the online course Intermediate (200)
        Has successfully completed the online course Advanced (300)
      5 years, 11 months 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
      Participant
        5 years, 11 months 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?

      Viewing 3 posts - 1 through 3 (of 3 total)

      You must be logged in to reply to this topic.