I faced a strange problem in select query. In my program I tried to select all the columns from a particular table in the order other than the table's column sequence.
For example Table1 is defined with the following column sequence Var1, Var2 , Var3 and my selection order is Va2, Var1, Var3. During execution Value of Var1 is moved to Var2 and Value of Var2 is moved to Var1. (which is the table's column sequence). In INTO I have given the dclgen variables in the selection order only(i.e. DCLVar2, DCLVar1 and DCLVar3).
Table has around 60 columns. This happens only if i select all the fields and I tried selecting some of the fields (In different order) and got the proper result.
What could be the reason for this? Is this due to Installation problem??
This happens only if i select all the fields (Around 60 fields, jayesh_g I never use Select * in my program )
If I select some of the fields (I tried upto 10 fields), It was working fine irrespective of the order of selection.
I guess this is due to Installation problem, Please let me know if you come across this type of error.