Selection Problem

[sganandhsg]

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

[QVeen72]

Hi,

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

Regards
Veena

[sganandhsg]

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

[QVeen72]

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

[sganandhsg]

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)

[QVeen72]

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

[sganandhsg]

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

[sganandhsg]

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...