VB 6.0 - How to handle error 3021, EOF or BOF is true

Asked By Swati Joshi on 19-May-06 11:57 AM
I have created a VB/access application. I save the records and call them back. when i run the programme if first record is not present it gives me run time error 3021.
how should I handle this ?

check IF not RS EOF and RS BOF - Asked By Shallu Gupta on 19-May-06 12:07 PM

Check 
If  NOT recordset.EOF and recordset.BOF 
Before actually looping through records

Handling EOF and BOF - Asked By Ramya T on 19-May-06 12:10 PM

Try like this when you get data from record set.
[CODE]
Dim sCmdOutput
Dim RecordSet
While Not RecordSet.EOF And Not RecordSet.BOF 
     Set sCmdOutput = RecordSet.Fields(0) 
            If IsNull(RecordSet.Fields(0)) Then 
            	                RecordSet.MoveNext
                                Set sCmdOutput = RecordSet.Fields(0)
               Else
                                Wscript.Echo sCmdOutput
                                RecordSet.MoveNext
               End If
  Wend     
[/CODE]

oracle9i - Asked By paraman thinesh on 02-Jun-06 05:13 AM

how can save a picture in oracle9i data base ?
shajin replied to Swati Joshi on 10-Jan-11 12:46 AM
this code working sucessfully.