[PyKDE] QSqlRecord - adding a field (PyQt)
    joanne matthews (RRes-Roth) 
    joanne.matthews at bbsrc.ac.uk
       
    Tue Jan 23 13:11:35 GMT 2007
    
    
  
I'm just trying to add a field to a record like this:
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName("databaseName")
rec=db.record("tableName")
if not rec.contains("fieldName"):
    fieldNotExistError("tableName","fieldName")
    #fieldName=QtSql.QSqlField("exportGIS",QtCore.QVariant.Int)
    fieldName=QtSql.QSqlField()
    fieldName.setName("fieldName")
    fieldName.setType(QtCore.QVariant.Int)
    print db.lastError().text()
    rec.append(fieldName)
But it doesn't append the field. I've also tried rec.insert() but that
doesn't insert the field either. I don't get any error messages printed.
Can someone tell me what I'm doing wrong.
Thanks
    
    
    
More information about the PyQt
mailing list