Hello everyone
I'm having a weird / annoying problem. Let me first tell what I am trying to do.
I have a table which contains 150 connections (these are comparable with houses that all have addresses). I need to update each of these connection rows to specify a sequenceId which is a column in this table.
The sequenceId comes from c# and works like a sharm.
I tried three different solutions and none of them works.
First the "while select", which should iterate over the 150 addresses and in the while I can process things.
Code example 1: http://gyazo.com/4aabe1768be54ca560c278f2db5de464.png
That didn't work so I tried a more solid solution, the for-loop which I am sure that it iterates 10 times (for testing purposes). But this time it doesn't switch the ConnectionId (which I want from every row so I can update one specific row).
Code example 2: http://gyazo.com/40a99d1de1c92c48bff38b976fa6756c.png
And last what I found here on the forum with the "next" in a while loop.
Code example 3: http://gyazo.com/79e5f186fad79f971872e95016025a27.png
Summary:
- first example only loops ones (if I do count() I get 150)
- second example loops 10 times, but doesn't change the connectionId
- third example loops also 10 times and doesn't change the connectionId either
I hope someone can help me. My appologies already if I did something stupid in the code examples but I'm learning AX for 2months now (on my own).
Sincerly,
Vincent
