Im a beginer for the coding

Question

1.00/5 (1 vote)

See more:

can some body please explain me that what is mean by unused local variable and how we have to create it for exam i have a coding in that the Waring message came to me that unused local variable

Dim sub1(HERE IT SHOW ME THAT UNUSED LOCAL VARIABLE) As String
           OleDbConnection1.Open()
           Dim str As String
           str = "select brrelno from submaster where subcode=@subcode"
               Dim cmd As OleDbCommand
               Dim cmd1 As OleDbCommand
           cmd = New OleDbCommand(str, OleDbConnection1)
               cmd.Parameters.AddWithValue("@subcode", Application("subcode"))
           res = cmd.ExecuteScalar
           cmd.Connection.Close()

What I have tried:

what that its mean and please tell that how to clear this problem

Posted 21-Jan-20 17:43pm

nehaperiyasamy

Updated 22-Jan-20 0:36am

Add a Solution

Comments

Richard MacCutchan 22-Jan-20 3:59am

Whatever variable you have declared in the sub1 definition (where you have written: "HERE IT SHOW ME THAT UNUSED LOCAL VARIABLE"), is never referenced in the following code.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2020-01-22T00:37:00

Quote:
can some body please explain me that what is mean by unused local variable

May be it is this unused variable:

VB

Dim sub1(HERE IT SHOW ME THAT UNUSED LOCAL VARIABLE) As String
           OleDbConnection1.Open()
           Dim str As String
           str = "select brrelno from submaster where subcode=@subcode"
           Dim cmd As OleDbCommand
           Dim cmd1 As OleDbCommand
           cmd = New OleDbCommand(str, OleDbConnection1)
           cmd.Parameters.AddWithValue("@subcode", Application("subcode"))
           res = cmd.ExecuteScalar
           cmd.Connection.Close()

Doug- VisualBasic VB.NET · Answer 2 · 2020-01-21T19:16:00

Solution 1

Please post the actual contents of:
Dim sub1(HERE IT SHOW ME THAT UNUSED LOCAL VARIABLE) As String

My thought is you are defining a variable in this location, that you are not using.

Posted 21-Jan-20 19:16pm

Doug- VisualBasic VB.NET

phil.o · Answer 3 · 2020-01-21T22:56:00

Probably you are trying to use a variable which you did not define yet (or trying to use a local variable to a function which has become inaccessible outside of its function).

VB

Dim count As Integer = 42
Dim sub1(count) As String '' Will work and define a string array with 42 elements
Dim sub2(unknown) As String '' Will raise an error when unknown variable is used

Your naming is ambiguous, though. You may as well want to define a function, but functions are not defined with Dim keyword:

VB

Public Function sub1(ByVal variable As Integer) As String
   '' ...
End Function

Im a beginer for the coding

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0