ADO Recordset Only Returning 1 Value

Hi,

I have a pretty long procedure, and part of which is mentioned below (Most Probably the part causing issue)

Please Login or Register  to view this content.

RetriveValue is basically a SQL Query -

For example select PremiumPct from DBCommon..RespDetails where ID = 775719

This query generates a value based on a unique Id (775719) this ID will change every time the Procedure runs.

I only get the RS to retun value for the 1st loop, and then everytime it retuns Null.. However when I check the DB, values are being generated for all IDs.

Can anyone suggest what might be wrong?

Would need to see you query statement