Looping through an SQL query - End of Recordset?

Hi All,

 

Can someone please tell me how I can loop through a returned result set
of an SQL query until there are no more records left?

 

Pseudo code-wise, I need something like this:

 

SQL: Select * from myfile where myvalue = something

 

If SQLCOD = 0 then

  Dow not end_of_query()

    (Do some processing)

    (Go to the next record)

  Loop

End if

 

I usually read a file until there are no more records, but I haven't
done it yet with the returned recordset from an SQL statement.

 

Thanks,

 

Brian.

 

 

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

Ph: 705-435-7814 x343

Fx: 705-435-6746

-=-=-=-=-=-=-=-=-=-=-=-=-=-