No given for one or more required parameter

Question

0.00/5 (No votes)

See more:

Hi all.
I wanna delete the special table record with INNER JOIN relationship in ACCESS 2010 and C#.net. but I have following error :

No given for one or more required parameter

SQL

DELETE DISTINCTROW  Ghesting.*
 FROM  ((kala INNER JOIN buyer ON kala.buyer_codem = buyer.code_m_buyer) INNER JOIN Ghesting ON buyer.code_m_buyer = Ghesting.fk_code_m_buyer) 
WHERE ([buyer.code_m_buyer] =[?]) AND (kala.serial_kala=?)

Posted 22-Mar-15 4:36am

bernova

Updated 22-Mar-15 4:53am

v3

Add a Solution

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)

phil.o · Answer 1 · 2015-03-22T04:42:00

Solution 1

You don't really need the JOINs here, as you just want to delete the rows with specific value:

SQL

DELETE FROM Ghesting WHERE fk_code_m_buyer = ?

But you need to supply the parameter: this is the problem that is stated, you did not provide the required parameter.

Maybe:

C#

yourCommandObject.Parameters.AddWithValue("fk_code_m_buyer", yourValue);

should do it.

[EDIT] Solution with the correct example [/EDIT]

SQL

DELETE FROM Ghesting INNER JOIN buyer ON buyer.code_m_buyer = Ghesting.fk_code_m_buyer INNER JOIN kala ON kala.buyer_codem = buyer.code_m_buyer WHERE fk_code_mbuyer = ? AND kala.serial_kala = ?

You still have to provide both parameters when executing the query, though.

As a general advise, you really should normalize the way you are naming your columns, that would make your queries less complicated, more readable, and less prone to typos.
And, second one, when you post a question, please be carefull to give all the relevant and exact details the first time; it will prevent us from wasting our time :)

Kindly.

Posted 22-Mar-15 4:42am

phil.o

Updated 22-Mar-15 5:31am

v2

Comments

bernova 22-Mar-15 11:00am

thanks phil.o , but i should pass two parameter to query , because i want to delete special record , not all of records.

the problem is that don't be pass parameters to delete query with innerjoin relationship.

I test my Query in Query design and this error shows in query design not in Visual C#.net

phil.o 22-Mar-15 11:31am

Please see my updated solution.

bernova 22-Mar-15 11:51am

Excuse me.

bernova 22-Mar-15 12:01pm

yet I have following error :
No given for one or more required parameter

phil.o 22-Mar-15 12:04pm

What do you think that means? :)

bernova 22-Mar-15 12:04pm

when I test above query as following in WHERE parameters

WHERE fk_code_mbuyer = "2366381" AND kala.serial_kala = "202030"

run correctly. but when pass parameter with (?) shows error.

phil.o 22-Mar-15 12:11pm

Because when you write ? in the query, you're just telling your database engine: ok, I don't have the exact value for this at the moment, I'll provide it to you when I want you to execute it.
See my first answer regarding how to provide the value to a parameter from C# code.

bernova 22-Mar-15 12:19pm

I test first answer as follow :

public void disable_ghesting(string U_codem,string serial_kala)
{
string _comm_delete_ghest = "DELETE DISTINCTROW Ghesting.* FROM ((kala INNER JOIN buyer ON kala.buyer_codem = buyer.code_m_buyer) INNER JOIN Ghesting ON buyer.code_m_buyer = Ghesting.fk_code_m_buyer) WHERE ([Ghesting.fk_code_m_buyer] = ?) AND ([kala.serial_kala]= ?))";

OleDbParameter[] pa_delete_ghest = new OleDbParameter[2];
pa_delete_ghest[0] = new OleDbParameter("fk_code_m_buyer", OleDbType.Char);
pa_delete_ghest[0].Value = Convert.ToString(U_codem);
pa_delete_ghest[1] = new OleDbParameter("serial_kala",oledbtype.char);
pa_delete_ghest[1].value = convert.tostring(serial_kala);
a.query_Delete_command(_comm_delete_ghest, pa_delete_ghest);
}
but i have same error. i write project in form three-layer

phil.o 22-Mar-15 12:25pm

Put a breakpoint on a.query_Delete_command(_comm_delete_ghest, pa_delete_ghest); line, press F5, and then debug your application. There is no way I can figure out the problem without any information.