3 Replies Latest reply: Jul 25, 2016 6:16 AM by Digvijay Singh RSS

    How to manually Insert Data into Table?

      Hey all,


      in the script editor, while loading I want to add lines to a (inlined) table.


      At the moment I'm doing this via the concatenate command like this:


      sub LogDb (pMessage)

        let vLogDate = timestamp(now(), 'DD.MM.YYYY hh:mm:ss.ff');



        Load * inline [

            MessageDate, Message

            $(vLogDate), $(pMessage)


      end sub;


      This seems pretty clunky. I wondered if there is something like an INSERT or APPEND command, but couldn't find any in the documentation nor any apropriate discussion here in the community.


      So my question: Is this the way you do it, or is there a different (better) way to achieve that?


      Kind regards



      Edit: clearified scope