> > So my question is: is it possible to change the default type for > > INTEGER to QVariant::Int from qlonglong? > > Or even better, is it possible to change that for just a selected > > column in the QSqlTableModel? > > That would be a clean solution. > > > > Another good solution would be to set a delegate/editor for qlonglong, > > but do we have a better way than creating a subclass of QItemDelegate > > or QItemEditorCreatorBase with 50+ lines of code? > > > > tr3w > > Well, I think the issue is that QSpinBox is limited to an int range, so > it can't be used for qlonglong. > > For your case, I think I would make a simple proxy model based on > QIdentityProxyModel that adapts the data type from longlong to int when > possible and where desirable. That should only take a couple of loc. I > don't think it will be easy to coax the driver into using int instead of > longlong. >
Actually, the driver is probably doing something pretty reasonable. SQLite itself has a rather unsual (if not unique) type system. The delegate and proxy workarounds have already been mentioned. Another possibility is a subclass of your model that adjusts the type. Mak _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
