Hi Friends

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I am getting the error while Select the Data...

How to clear this type of errors.... Any one Help Me

Recommended Answers

All 7 Replies

Hi,

This is normally due to difference in Data-types..
Post your Select statement here..

Regards
Veena

Hi,

This is normally due to difference in Data-types..
Post your Select statement here..

Regards
Veena

Thanks For Ur Replay

Statement for Selection

rs.Open "Select * from employee where emp_code='" & ListView2.SelectedItem.Text & "'", con, adOpenDynamic, adLockOptimistic

Hi,

I guess, Emp_Code is a Numeric Field in Database..
Dont Wrap it with Single quotes:

rs.Open "Select * from employee where emp_code=" & Val(ListView2.SelectedItem.Text )& "", con, adOpenDynamic, adLockOptimistic

Regards
Veena

Hi,

I guess, Emp_Code is a Numeric Field in Database..
Dont Wrap it with Single quotes:

rs.Open "Select * from employee where emp_code=" & Val(ListView2.SelectedItem.Text )& "", con, adOpenDynamic, adLockOptimistic

Regards
Veena

No... The emp_code is "Text" like a code as (00A001)

Hi,

What all is populated in the List View..?
May be, you want to refer to a SubItem of the list view...(instead of seleted item's text..)
Check how is "rs" declared..?
Connection object is open..


Regards
Veena

Hi,

What all is populated in the List View..?
May be, you want to refer to a SubItem of the list view...(instead of seleted item's text..)
Check how is "rs" declared..?
Connection object is open..


Regards
Veena

Ok.... But the same package running for Windows XP, win98 system can`t run.... this is find out before 2 hours back...


Thanks & Regards
Anandh

Hi,

What all is populated in the List View..?
May be, you want to refer to a SubItem of the list view...(instead of seleted item's text..)
Check how is "rs" declared..?
Connection object is open..


Regards
Veena

Hi... Veena


U have any idea abt this Selection process...

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.