943,648 Members | Top Members by Rank

Software Development > Visual Basic 4 / 5 / 6 > Selection Problem
Ad:
Permalink
Nov 7th, 2008
0

Selection Problem

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 1
Light Poster
sganandhsg is offline Offline
39 posts
since Sep 2008
Permalink
Nov 8th, 2008
0

Re: Selection Problem

Hi,

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

Regards
Veena
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Permalink
Nov 8th, 2008
0

Re: Selection Problem

Click to Expand / Collapse  Quote originally posted by QVeen72 ...
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
Reputation Points: 10
Solved Threads: 1
Light Poster
sganandhsg is offline Offline
39 posts
since Sep 2008
Permalink
Nov 8th, 2008
0

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
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Permalink
Nov 10th, 2008
0

Re: Selection Problem

Click to Expand / Collapse  Quote originally posted by 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

No... The emp_code is "Text" like a code as (00A001)
Reputation Points: 10
Solved Threads: 1
Light Poster
sganandhsg is offline Offline
39 posts
since Sep 2008
Permalink
Nov 10th, 2008
0

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
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Permalink
Nov 10th, 2008
0

Re: Selection Problem

Click to Expand / Collapse  Quote originally posted by 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


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
Reputation Points: 10
Solved Threads: 1
Light Poster
sganandhsg is offline Offline
39 posts
since Sep 2008
Permalink
Nov 17th, 2008
0

Re: Selection Problem

Click to Expand / Collapse  Quote originally posted by 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


Hi... Veena


U have any idea abt this Selection process...
Reputation Points: 10
Solved Threads: 1
Light Poster
sganandhsg is offline Offline
39 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Option Slection
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Can I restrict email sent in Outlook without using Exchange?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC