Selection Problem
 

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

Re: Selection Problem
 

Hi,

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

Regards
Veena

Re: Selection Problem
 

Thanks For Ur Replay

Statement for Selection

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

Re: Selection Problem
 

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

Re: Selection Problem
 

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

Re: Selection Problem
 

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

Re: Selection Problem
 

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

Re: Selection Problem
 

Hi... Veena


U have any idea abt this Selection process...