Hi Group,
I have a very strange problem.
I have a table and have built Views on that Table.
I have built a view which fills the value 1 into a Column which is Grouped by OrderNumber and Position Number.
I hve built another view on the top of this view which is Grouped by Order Number, Position Number and Sequence Number. When I insert Values into this view , I get followint Result :
OrderNo PositionNo SequenceNo NoOrderLines
100 10 0 1
100 20 1 NULL
100 30 2 NULL
When I try to fill in the NULL values by 0 by using the condition IsNull(NoOrderLines, 0) then it doesn't get filled by 0. Instead it gets filled by 1.
I have a another column in which I fill the Null vales by 0 in teh similar fashion and I get correct results there.
Can anyone please help me as to what the problem might be with this column???
Regards,
ashark
I have a very strange problem.
I have a table and have built Views on that Table.
I have built a view which fills the value 1 into a Column which is Grouped by OrderNumber and Position Number.
I hve built another view on the top of this view which is Grouped by Order Number, Position Number and Sequence Number. When I insert Values into this view , I get followint Result :
OrderNo PositionNo SequenceNo NoOrderLines
100 10 0 1
100 20 1 NULL
100 30 2 NULL
When I try to fill in the NULL values by 0 by using the condition IsNull(NoOrderLines, 0) then it doesn't get filled by 0. Instead it gets filled by 1.
I have a another column in which I fill the Null vales by 0 in teh similar fashion and I get correct results there.
Can anyone please help me as to what the problem might be with this column???
Regards,
ashark