ADO - Recordset Query Not Executing

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

[askus]

send me the code, i think probablity of the recordset being change after that particular line its getting reset so, make it fast to make it work for u

reg



The Ultimate Solution Providers

Authors

Sriman & Jayaraman

Email : [email protected]
[email protected]

Hand Phone : +(6) 016 2237147 (Malaysia)

[Crazy D @ Work]

If it works when you step-through the code, and it doesn't at runtime, use doevents after opening the recordset.

Crazy D @ Work :-)