Check if a row exists Update Record, otherwise insert In Database

M4RZB4Ni

Hello
i want to add some records to a database But i want to when User
Clicked on the Button Program in the Begning Check if a row exists Update The Record, otherwise insert in Table
I searched in Google For This,But Only Found SQL STATMENTS FOR STORED PROCEDURES Not C++ Codes Or Notes
Anybody can Help me Please?

SGaist

Hi,

Which type of SQL database are you targeting ? If SQLite, then you can do it in one query directly.

Otherwise (and since you don't want to use only SQL), you'll have to run a select query to check if what you search already exist and based on that, call either an insert or update query. All this using QSqlQuery.

Hope it helps.

M4RZB4Ni

@SGaist
Thanks
I use SqlServer 2014
i know this method
but i dont know how we Understand that Record exists ?
Can you Write a sample Example?
Thanks again

jsulm

@M4RZB4Ni Use SQL count() function: http://www.w3schools.com/sql/sql_func_count.asp

the_

@M4RZB4Ni

I have never used MSSQL Server but a quick search on <whatever> tells me that a simple insert into on duplicate key update (as in mysql) or replace into (sqlite) is not supported. (both needs unique constraints for several keys in the table)

Examples how to solve this with SQL statements directly can be found here:

http://stackoverflow.com/a/12202
http://stackoverflow.com/a/108420

VRonin

If you have SQL server why not just create a stored procedure in the server and call it in C++?! It's the best option under all circumstances.

If you can't use that then use a select then use something like:

bool alreadyExist = false;
{
QSqlQuery query;
query.prepare("select * from MyTable where rowID=:rowID");
query.bindValue(":rowID",rowID);
if(!query.exec()){
// select failed
}
alreadyExist = query.next();
}
if(alreadyExist){
// update
}
else{
//insert
}