Visual Basic 4 / 5 / 6 RSS Visual Basic 4 / 5 / 6 RSS

Selection Problem

Reply

•
•
Join Date: Sep 2008
Posts: 29
Reputation: sganandhsg is an unknown quantity at this point 
Solved Threads: 1
sganandhsg sganandhsg is offline Offline
Light Poster

Selection Problem

 
0
  #1
Nov 7th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2006
Posts: 848
Reputation: QVeen72 is on a distinguished road 
Solved Threads: 120
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Practically a Posting Shark

Re: Selection Problem

 
0
  #2
Nov 8th, 2008
Hi,

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

Regards
Veena
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 29
Reputation: sganandhsg is an unknown quantity at this point 
Solved Threads: 1
sganandhsg sganandhsg is offline Offline
Light Poster

Re: Selection Problem

 
0
  #3
Nov 8th, 2008
•
•
•
•
Originally Posted by QVeen72 View Post
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2006
Posts: 848
Reputation: QVeen72 is on a distinguished road 
Solved Threads: 120
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Practically a Posting Shark

Re: Selection Problem

 
0
  #4
Nov 8th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 29
Reputation: sganandhsg is an unknown quantity at this point 
Solved Threads: 1
sganandhsg sganandhsg is offline Offline
Light Poster

Re: Selection Problem

 
0
  #5
Nov 10th, 2008
•
•
•
•
Originally Posted by QVeen72 View Post
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)
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2006
Posts: 848
Reputation: QVeen72 is on a distinguished road 
Solved Threads: 120
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Practically a Posting Shark

Re: Selection Problem

 
0
  #6
Nov 10th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 29
Reputation: sganandhsg is an unknown quantity at this point 
Solved Threads: 1
sganandhsg sganandhsg is offline Offline
Light Poster

Re: Selection Problem

 
0
  #7
Nov 10th, 2008
•
•
•
•
Originally Posted by QVeen72 View Post
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 29
Reputation: sganandhsg is an unknown quantity at this point 
Solved Threads: 1
sganandhsg sganandhsg is offline Offline
Light Poster

Re: Selection Problem

 
0
  #8
Nov 17th, 2008
•
•
•
•
Originally Posted by QVeen72 View Post
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...
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



* 6 2007 access activex add age basic beginner birth bmp calculator cd cells.find click client code college connection connectionproblemusingvb6usingoledb creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit excel excelmacro file filename form header iamthwee image inboxinvb internetfiledownload listbox listview liveperson login looping microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading remotesqlserverdatabase report save search sendbyte sites sql sql2008 sqlserver subroutine tags time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC