error while insert a record to ms access

Question

I have executed the above query, and I got an error :

{System.Data.OleDb.OleDbException: Syntax error. in query expression 
'Select [UserID] from UserDetails'

and my sample code is below:

OleDbCommand cmd1 = new OleDbCommand("Insert into UserCompanyDetails([UserID],[CompanyID]) values (" + "Select [UserID] from UserDetails" + "," + "Select @@identity" + ");", conn);
                        conn.Open();
                        cmd1.ExecuteNonQuery();
                        conn.Close();

Why am I getting this error?

score 0 · Answer 1 · answered Jun 06 '13 at 09:15

0

You should put your subqueries between parentheses:

"Insert into UserCompanyDetails([UserID],[CompanyID]) values ((Select [UserID] from UserDetails),(Select @@identity))"

answered Jun 06 '13 at 09:15

Pragmateek

13,174
9
74
108

while i execute your code i got the error Syntax error. in query expression '(Select @@identity)' – Siva Jun 06 '13 at 09:32
Then try to use directly @@identity without selecting it. – Pragmateek Jun 06 '13 at 09:49

score 0 · Answer 2 · answered Jun 06 '13 at 09:17

0

Another approach:

Try to save the results of the following queries in variables of their respective datatypes.

Select [UserID] from UserDetails
Select @@identity

Then you can simply use those variables in your Main Query String

answered Jun 06 '13 at 09:17

Safeer

184
3
17

error while insert a record to ms access

2 Answers2