I have a very odd problem and not sure what is causing it.
I have a form that allows me to enter a transaction. The form has multiple windows, each window allowing different line types to be entered.
As each line is entered, the details of the line are refreshed onto the main screen into a scrolling window as per below.
The last column on the scrolling window is not an amount, it is a sequence number which I have temporarily unhidden. Now, for some reason, the sequence number of every line is the same, even though the underlying temp table that the data is saved in is correct.
So, the first line actually has a sequence number of 512, the 2nd line 1024, etc. I deleted a line which is why the sequence ended up at 2048 instead of 1536.
At the end of the entry window, I do a fill window LineScroll from current.
I have tried adding this line to the line fill script to resolve the issue but no luck
SequenceNo of window LineScroll = SequenceNo of table TempTable;
The really odd thing here is that after entering each line, the sequence number for all lines is changed. So, when there was only 1 line, the sequence number for that line was 512. When I entered the 2nd line, both lines changed to 1024, even though the temp table had 512 and 1024.
Any ideas???? I have been testing and scratching my head about this for 2 days now.
The even stranger part is I have another screen that does something similar and that one works perfectly. I have compared all the scripts between the 2 forms and they are basically the same.
Cheers,
Mark
EDIT: We found the cause of the issue with a call to another routine at the end of the line fill script.