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

    How to manually Insert Data into Table?

    Sebastian Moos

      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');

       

        Concatenate(LogTable)

        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

      Sebastian

       

      Edit: clearified scope