Argument error; the number of columns does not equal the number of parameters.

[dhanushmh]

Hi, I'm facing the below error while inserting the data to SQL server.

Argument error; the number of columns does not equal the number of parameters.

I tried adding column names.

Attaching VI file.

[cbutcher]

If your query is "select top 1 * from recomp1" do you mean "select * from recomp1 limit 1;" or similar?

[dhanushmh]

I'm just taking first row from that particular database. 

Later I will take whole database and try.

[cbutcher]

What I mean is I don't think SELECT TOP 1...  is standard SQL. My guess is you want what I wrote above. Or is top an extension with your dbms?

[dhanushmh]

I'm using Microsoft SQL. It works properly using this query. 

I'm Getting output, but the problem is when I try to store the data back to Database, its giving the above error.