error while executing following c# code

Question

I had try to delete a row in a table using the following code, but I got an error.

{System.Data.OleDb.OleDbException: Missing ), ], or Item in query expression 
'[CompanyID] not in (Select [CompanyID] from EmployeeDetails 
where [CompanyID] = @cmpID'.

Here is my code:

int companyID = _cmpDetailsList[i].CompanyID;        
OleDbCommand upcmd = new OleDbCommand(
    "delete * from CompanyDetails where [CompanyID] not in " + 
    "(Select [CompanyID] from EmployeeDetails where [CompanyID] = @cmpID", conn);
conn.Open(); 
upcmd.Parameters.AddWithValue("@cmpID", companyID);
upcmd.ExecuteNonQuery();
conn.Close();

i modified the command to in this format

OleDbCommand upcmd = new OleDbCommand("delete * from CompanyDetails where [CompanyID]= @cmpID and not in (Select [CompanyID] from EmployeeDetails where [CompanyID] = @cmpID)", conn);

i got the following error

System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '[CompanyID]= @cmpID and not in (Select [CompanyID] from EmployeeDetails where [CompanyID] = @cmpID)'.

please solve it

it works for the case Select * for delete its the entire row so just delete from ... — V4Vendetta
– V4Vendetta, Commented Jun 6, 2013 at 7:11

Damien_The_Unbeliever · Accepted Answer · 2013-06-06 07:11:11Z

9

If you read the error, it tells you the problem:

OleDbCommand upcmd = new OleDbCommand(
"delete from CompanyDetails where [CompanyID] not in " + 
"(Select [CompanyID] from EmployeeDetails where [CompanyID] = @cmpID)", conn);

You had a ( but no matching ) at the end.

answered Jun 6, 2013 at 7:11

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

NDJ Over a year ago

delete * from is valid for access...not sure what the op is using though

V4Vendetta Over a year ago

+1 One more thing if you could add is the usage of @ string literal which would have made the query easier to read and spot the missing braces, the good thing is OP using parameters

Collectives™ on Stack Overflow

error while executing following c# code

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related