Fetch default values from MySQL?

[arimaniac]

Hello guys...

One question of faith... :P

I wrote an application that uses QSqlTableModel to access MySQL, add, insert, delete, update records in several tables etc etc etc...

How do I get the default values for each table after I use the insertRow() to insert new records
AS THEY ARE specified in MySQL...

In other words:
I need to read those values from MySQL, NOT to set them programmatically
within Qt (i.e setData)....

Does this functionality even exist???

Thanks
Aris

[arimaniac]

ok.. so query the db for default values...

desc <table name>;

desc <table name>;

To copy to clipboard, switch view to plain text mode 

should also work then..
THANKS!

---

Added after 25 minutes:

SOLUTION :

QSqlQuery query("desc "+TableName);
    int i = 0;
    while (query.next()) {
        if(i)
        {
            QString val = query.value(4).toString();
        if( val!= "")
            {
            myDataModel->setData(DataModel->index(DataModel->rowCount()-1 , i ) , val , Qt::EditRole);
            }
        }
        i++;
    }

QSqlQuery query("desc "+TableName);
    int i = 0;
    while (query.next()) {
        if(i)
        {
            QString val = query.value(4).toString();
        if( val!= "")
            {
            myDataModel->setData(DataModel->index(DataModel->rowCount()-1 , i ) , val , Qt::EditRole);
            }
        }
        i++;
    }

To copy to clipboard, switch view to plain text mode