Advertisement

06.16.2007 at 12:54AM PDT, ID: 22638077
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.4

Upgrading a VB6 App to Visual 2005

Asked by neoice in Microsoft Visual Basic.Net, Visual Basic Programming

Tags:

Hi,

I have recently updated a VB6 application into a Visual 2005 windows application. I have resolved most of the differences apart from the following:

 Private Sub CbIntake_SelectedIndexChanged(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles CbIntake.SelectedIndexChanged

CBPerson.Items.Clear()

        ssql3 = "select * from QryStudentDetails where intake = " & CbIntake.Text & " order by fullname asc"

        cn3 = New ADODB.Connection

        cn3.Open(sconnect)

        rs3 = New ADODB.Recordset


        rs3.CursorLocation = ADODB.CursorLocationEnum.adUseClient
       
** rs3.Open(ssql3, cn3, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockUnspecified) 'ADODB.CursorTypeEnum.adOpenDynamic) , ADODB.LockTypeEnum.adLockOptimistic) **
        rs3.MoveFirst()

        Do Until rs3.EOF = True
            CBPerson.Items.Add(rs3.Fields("fullname").Value) 'add names to combo box
            rs3.MoveNext()
        Loop
            
      End Sub
The program is halted with a "com exception was unhandled" error and highlights the section above (marked with **)

In the immediate window I type ?ssql3 and the query seems fine:

"select * from QryStudentDetails where intake = 10 order by fullname asc"

if I change the query to "select * from QryStudentDetails" then the program does not halt but obviously I end up with unfiltered data.
The code works fine in VB6

Any ideas will be much appreciated.

Neil
Start Free Trial
[+][-]06.16.2007 at 01:26AM PDT, ID: 19297436

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 03:10AM PDT, ID: 19297611

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 03:46AM PDT, ID: 19297654

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 04:14AM PDT, ID: 19297715

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 05:48AM PDT, ID: 19297940

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:07AM PDT, ID: 19297984

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:13AM PDT, ID: 19297995

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:19AM PDT, ID: 19298017

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visual Basic.Net, Visual Basic Programming
Tags: vb6
Sign Up Now!
Solution Provided By: cheddar73
Participating Experts: 3
Solution Grade: A
 
 
[+][-]06.16.2007 at 06:25AM PDT, ID: 19298036

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:33AM PDT, ID: 19298059

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:34AM PDT, ID: 19298065

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2007 at 06:45AM PDT, ID: 19298112

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42