QUERY NOT WORKING

[SGaist]

Hi,

There might be some space missing in your query string.

You should also surround your query.exec call with an if or you will always print something.

You should also print the output of lastQuery.

On a side note, please don't write title in all caps. In written language it's considered shouting and rude.

[GREYON]

Okay for responding.but I don't understand when you say the maybe some space missing in the query.And where exactly can an If be there?

[SGaist]

The way you built your query string, "VALUES" is likely directly after the ")".

If (!query.exec()) {
    // put here the code that should run in case of failure
}

[GREYON]

@SGaist okay I get your point,However,the code is there it's only that I didn't include it when sending .it comes just after the **lastError ** line of code in my main code.

[mchinand]

Check the output of QSqlQuery::boundValues() (after the binding calls), QSqlQuery::lastQuery() and/or QSqlQuery::executedQuery() to see if anything looks different from what you expect.

[GREYON]

@mchinand Thanks let me try that way

[JonB]

@GREYON
@SGaist suggested you put a space into your )VALUES, did you at least try that?

Otherwise: reduce your statement down till it works. Try it with only the SURNAME/:SURNAME column in it. Yes, the INSERT will error before inserting because of a lack of columns, but you are only interested in trying to get as far as that, if you do not get the Parameter count mismatch error you have succeeded. Then add the other columns back in.

[GREYON]

@JonB Thanks, your idea of going through it one by one has worked thanks for your help

[Christian Ehrlicher]

So what was the actual error in your code above then?

[GREYON]

@Christian-Ehrlicher it's like one of the column name was not correctly spelled though I couldn't pin point it exactly cause I was just going through them one by one until all of them worked.