navigating within recordset created with oracle connectivity in vb

Question

deepika_rs 0 Newbie Poster

14 Years Ago

I have made a project in vb with oracle 9i at back end....its almost complete...
however i can't code the previous button on d form...

i used rs.moveprevious property but it generates an error...

help!!!

oracle visual-basic

3 Contributors
4 Replies
83 Views
6 Days Discussion Span
Latest Post 14 Years Ago Latest Post by deepika.rs5

AndreRet 526 Senior Poster

14 Years Ago

What kind of error is generated? Paste the code and show us on which line the error occurred.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

deepika.rs5 0 Newbie Poster · Answer 1 · 2010-10-04T18:55:46+00:00

rs2.MovePrevious

If (rs2.BOF) Then
MsgBox ("First Record")
Else
loadrec rs2
End If

Error:(on rs2.moveprevious)
runtime error 3219
Operation not allowed in dis context.

AndreRet 526 Senior Poster · Answer 2 · 2010-10-04T19:08:56+00:00

Try to change the rs2.MovePrevious to after loadrec rs2. The error seems to be raised before the rewcord is opened or reading for a BOF.

If (rs2.BOF) Then
MsgBox ("First Record")
Else
loadrec rs2
rs2.MovePrevious
End If

deepika.rs5 0 Newbie Poster · Answer 3 · 2010-10-09T12:14:43+00:00

hey thanx for replying.!!
But d code u suggested is generating d same error at d same statement(rs2.MovePrevious). Is der ny odr way to perform move previous operation i.e widout using MovePrevious property??