QSqlTableModel verticak header connect

[patrik08]

How i can connect a

vertikalheader = new QHeaderView(Qt::Vertical,this);

inside a QSqlTableModel to append context menu to remove line and dns helps.... ?

class DNS_model : public QSqlTableModel
    ..........
 
void DNS_model::refresh()
{
    const QString hostqueryx = QString("SELECT id,name,type,alias,ttl,value,prior,comment FROM DNSEntry WHERE name ='%1'")
    .arg(host);
    QSqlQuery query2sur(hostqueryx,db);
    setQuery(query2sur);
    setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
    setHeaderData(1, Qt::Horizontal, QObject::tr("DOMAINE"));
    setHeaderData(2, Qt::Horizontal, QObject::tr("TYPE"));   /* dnstype << "A" << "CNAME" << "NS" << "MX" << "TXT";  */
    setHeaderData(3, Qt::Horizontal, QObject::tr("ALIAS"));
    setHeaderData(4, Qt::Horizontal, QObject::tr("TTL"));   /* tooltip Time to Live domain on dns server */
    setHeaderData(5, Qt::Horizontal, QObject::tr("VALUE"));
    setHeaderData(6, Qt::Horizontal, QObject::tr("MX_PRIORITY"));
    setHeaderData(7, Qt::Horizontal, QObject::tr("COMMENT"));
}

class DNS_model : public QSqlTableModel
    ..........

void DNS_model::refresh()
{
    const QString hostqueryx = QString("SELECT id,name,type,alias,ttl,value,prior,comment FROM DNSEntry WHERE name ='%1'")
    .arg(host);
    QSqlQuery query2sur(hostqueryx,db);
    setQuery(query2sur);
    setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
    setHeaderData(1, Qt::Horizontal, QObject::tr("DOMAINE"));
    setHeaderData(2, Qt::Horizontal, QObject::tr("TYPE"));   /* dnstype << "A" << "CNAME" << "NS" << "MX" << "TXT";  */
    setHeaderData(3, Qt::Horizontal, QObject::tr("ALIAS"));
    setHeaderData(4, Qt::Horizontal, QObject::tr("TTL"));   /* tooltip Time to Live domain on dns server */
    setHeaderData(5, Qt::Horizontal, QObject::tr("VALUE"));
    setHeaderData(6, Qt::Horizontal, QObject::tr("MX_PRIORITY"));
    setHeaderData(7, Qt::Horizontal, QObject::tr("COMMENT"));
}

To copy to clipboard, switch view to plain text mode