Posts: 159
Threads: 1
Joined: Apr 2008
Reputation:
0
07-25-2008, 03:22 PM
Dear Siri,
You commented Rs.MoveNext ...
So that's why it is on only first record.
So take that out it is going to workout.
Posts: 160
Threads: 46
Joined: Feb 2008
Reputation:
0
07-25-2008, 04:17 PM
There are 5 records
SQL> Select Code, Meaning From TB_AMS052_Codes Where Code_Nam = 'Pole' ;
CODE
--------------------
MEANING
--------------------------------------------------------------------------------
1
Americas
2
Europe
3
Asia
CODE
--------------------
MEANING
--------------------------------------------------------------------------------
4
Global
5
Unknown
Posts: 160
Threads: 46
Joined: Feb 2008
Reputation:
0
07-25-2008, 04:21 PM
but i am specifying only the meaning
SQL> Select Meaning From TB_AMS052_Codes Where Code_Nam = 'Pole' ;
MEANING
--------------------------------------------------------------------------------
Americas
Europe
Asia
Global
Unknown
Posts: 159
Threads: 1
Joined: Apr 2008
Reputation:
0
07-25-2008, 04:31 PM
Hi,
That is fine..
But what is the recordcount in QTP message box you are getting.
Posts: 160
Threads: 46
Joined: Feb 2008
Reputation:
0
07-25-2008, 04:46 PM
Hi
I am getting as Americas in an infinite loop.
The next meaning is not populating
As i am taking the Meaning i am getting Americas and the next too americas instead of Europe
Msgbox rs.Fields("Meaning")
Posts: 160
Threads: 46
Joined: Feb 2008
Reputation:
0
07-25-2008, 04:58 PM
I believe the loop is not closed properly