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 - qsqltablemodel

Issues with row creation/deletion when editing QSqlTableModel via QTableView

I'm using PySide6 with Python 3.10 to create an app that is using an SQLite DB to record some data points. I'm having difficulties with the QtSql module, in particular regarding the QTableView-QSqlTab...
test-img

Kastakin

python

qtableview

pyside6

qsqltablemodel

Votes: 0

Answers: 1

Latest Answer

The issue here is with the structure of your database. Although it's valid to create a database with no primary key, this will usually cause problems, because it may force Qt to try to identify rows u...
test-img

ekhumoro

Update foreign key in Qt QSqlRelationalTableModel

I'm coding in python (PySide2), but the overall concept concerns the Qt Framework. Here are two tables of mine: Table "recordings": | Column | Type | | -------- | ---------...
test-img

Buzz

qt

foreign-keys

qsqltablemodel

qtqsqlrelationaltablemodel

Votes: 0

Answers: 1

Latest Answer

I've had the same problem using PYQT. The record object returned by calling record() method has no fields named 'rec_id' because the QSqlRelationalTableModel changes it with the referenced field name ...
test-img

Massimo Fuccillo

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

QSqlTableModel list of transactions

I am writing a PyQt6 QSqlTableModel application. I'm using manual update and submitAll(). I want to capture the sql statements which were successfully executed. The executedQuery() method reports only...
test-img

fossildoc

qsqlquery

qsqltablemodel

pyqt6

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs