Hi,

I am opening the recordset as follows

rsHistExm.Open "select distinct clg_id from history_examination_view order by clg_id ", gDbServer.ConnectionObj.ConnectionString, adOpenKeyset, adLockOptimistic

In this table named "History_Examination_view" records present is 1.

After execution of this query it is returning 0. But when the program in Break Mode placed exactly on this statement it is returning 1.

Why this problem is arising.. It seems to be very strange that when the break point is kept it is working, and when removed no process is
taking place.

Pl let me know immediately.

Regards

Prasad