Financial - JDE1 (MOSC)

MOSC Banner

Table IO multiple records

edited Feb 24, 2014 4:18PM in Financial - JDE1 (MOSC) 3 commentsAnswered
I have setup the following select statements
F0111.Select
F0111.Fetch Next
While SV File_IO_Status is equal to CO SUCCESS
   RV mnContactsCount = [RV mnContactsCount]+1
   //How do I retrieve inforation on the current record in the loop?
 F0111.Fetch Next
End While

In the select statement I pass, address book(AN8) and a Contact Type (NTYP). 

I know my select statement is working because it returns the correct count of records, 

My question is how do I get the line number out of the current records of the loop?

My goal in all of this is to return the first address book who's who line for a specific contact type. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center