Error: no value given for one or more required parameters

Question

0.00/5 (No votes)

See more:

Trying to update an old vb6 project, the query i am trying to run is working correctly when run on Access query builder, but when i copy this same query and try to run within vb6 it showing me error "error: no value given for one or more required parameters"

My query is:

VB

rs_store.Open ("SELECT store_exp.type, Sum(store_exp.amount) AS SumOfamount, First(store_exp.[amt type]) AS [FirstOfamt type] From store_exp GROUP BY store_exp.type"), cn

What I have tried:

working correctly in access query builder.

Posted 9-Jul-18 22:14pm

Sheraz M

Updated 9-Jul-18 23:08pm

CHill60

v2

Add a Solution

Comments

CHill60 10-Jul-18 5:07am

What if you get rid of the brackets () ?

1 solution

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)

Jochen Arndt · Answer 1 · 2018-07-09T23:09:00

Solution 1

Either remove the parentheses

VB

rs_store.Open "SELECT store_exp.type, Sum(store_exp.amount) AS SumOfamount, First(store_exp.[amt type]) AS [FirstOfamt type] From store_exp GROUP BY store_exp.type", cn

or pass all parameters including the optional ones enclosed by parentheses:

VB

rs_store.Open("SELECT store_exp.type, Sum(store_exp.amount) AS SumOfamount, First(store_exp.[amt type]) AS [FirstOfamt type] From store_exp GROUP BY store_exp.type", cn, adOpenForwardOnly)

Posted 9-Jul-18 23:09pm

Jochen Arndt

Comments

Sheraz M 10-Jul-18 9:35am

Tried both but not working
Either remove the parentheses - error expected expression
or pass all parameters including the optional ones enclosed by parentheses - same error not value given for one or more required parameters

Jochen Arndt 10-Jul-18 9:56am

Are you still using VB6 or VB.Net?

However, the second version still misses one or more parameter. Just check the documentation of the Open() function for the required parameters and add them. I would have done this initially but did not do so due to the lack of information about the type of rs_store (which would indicate the kind of database interface you are using).