python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - qtsql

Does Qt SQL models support UPSERT?

I'm now using Qt SQL in my application, and I'm able to execute the following script (aka UPSERT) by using QSqlQuery: INSERT INTO table_1(col_1,col_2,col_3) VALUES(val_1,val_2,val_3) ON CONFLICT(col_1...
test-img

Aurus Huang

qt

model

upsert

qtsql

Votes: 0

Answers: 1

Latest Answer

No, UPSERT is not implemented in Qt because it has different syntax on different database systems. But you can implement it this way: override QSqlTableModel::insertRowIntoTable implement upsert stat...
test-img

mugiseyebrows

QtSQL error: SQLITE driver doesn't recognize my DB file as a database

the title mostly explains the problem. I am using Qt 6 and the SQL module to connect to a external SQL database file (format is simply .db), in order to learn how SQL management via Qt works. I learne...
test-img

byjove

c++

sql

sqlite

qt

qtsql

Votes: 0

Answers: 0

How to submit data to the QSqlTableModel that has been changed by the user on the QTableView

I'm trying to retrieve the input from the user when modifying the QTableView as seen in the photo and then updating the QSqlTableModel in order to get my database modified. The problem is that QTable...
test-img

Marçal Xena

python

qt

qtableview

qtsql

qsqltablemodel

Votes: 0

Answers: 1

Latest Answer

Model has dataChanged(topLeftIndex, bottomRightIndex) signal, model emits this signal every time user edits anything, you can get value from index: topLeftIndex.data().
test-img

mugiseyebrows

Error conecting SQLOLEDB with QtSQL / QSqlDatabase

I'm struggling to get a connection using QtSql. The problem is that my type of connection is a "SQLOLEDB", and I can only find ODBDC examples... Please any help would be so much appriciated!...
test-img

Marçal Xena

python

qt

oledb

pyside2

qtsql

Votes: 0

Answers: 1

Latest Answer

Finally I've managed to connect to the server using a DSN like this: db32 = QSqlDatabase.addDatabase("QODBC") db32.setHostName("yourServerHost") db32.setDatabaseNam...
test-img

Marçal Xena

Posts

Questions

Blogs

Jobs