Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you need something like below in Insert menu of script editor?
Insert-->Load Statement-->Load Inline
Hey,
no, not really, I'm just asking, if there is a more viable way then creating a new inline table and concatenating it with the existing one. Something like a "INSERT" command in SQL.
Thanks for your answer though.
cheers
sebastian
don't think so AFAIK for the data created in script. Let us hear from other experts though!