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.