[Joey Tribbiani]

Hi Uwe!

For “a)” I would as Andreas suggested use a CSV conversion. So probably the CSV-Conversion done as in the technical note would solve all your stated problems.

Anywho… I got a bit curious, why the list entries to row conversion does not work out for you. So I gave it a try. But the weird thing is, that I’ve got it working just right – immediately. – So I had a look at your code again.

And there it is. So the error is actually in your code. So to make it short:

– Replace the … .$addcols() … function with $cols.$add()

– And also use $sendallref.$name in the $add() function. Because $ref will not work in this scope

I’ve tinkered a little sample app for this just for fun. So if you wanna have look – see the library in the attachment.

Note: When I’ve got the time for it, I will also convert the library into a CE one – so everyone in this forum can have a look at it.

Have a good one!

nto1_conv.lbs 50 KB Omnis LBS - Click to view

Options

• Copy Download Link

[Joey Tribbiani]

Edit: I’ve forgot to mention that I would and will also work with the used $addcols() function, if you just wanna replace the $ref with $sendallref. But I suggest to also change $addcols() to $cols.$add() because this is the “right way” of doing it.

This because $sendall() is nothing else than a loop but much more efficient. So it will iterate through the lines of the list and insert a new column for every line, and it will call the $addcols() function for every singe line. This will result in a $addcols function being used for only one column at a time, which is not the real purpose of the $addcols function. In the case of just adding one column it is better and more clean to use the $cols.$add.

Joey