Retrieve full decimal value from MySql database?

[adutzu89]

When I retrieve decimal data from MySql if the value is Example: 10.00 it retrieves 10.
I retrieve the data using:

while(query.next()){
        QString number=query.value("decimalColumn").toSomething(); //tried toString(),toDouble(),toFloat() and all are retrieving the same
    }

while(query.next()){
        QString number=query.value("decimalColumn").toSomething(); //tried toString(),toDouble(),toFloat() and all are retrieving the same
    }

To copy to clipboard, switch view to plain text mode 

How can I setup so I retrieve full decimal value even if its *.00 ?

I can change fairly easy if the number appears like 99, but I get numbers like 99.90, so it if I append .00 there will be the issue of numbers appearing like 99.90.00.

[stampede]

Convert the query value to float and use QString::number (double n, char format, int precision) method to convert it to string (see argument formats).
In your case QString::number(value,'f',2) should be ok

while(query.next()){
    const float v = query.value("decimalColumn").toFloat();
    const QString number = QString::number(v,'f',2);
    ...
}

while(query.next()){
    const float v = query.value("decimalColumn").toFloat();
    const QString number = QString::number(v,'f',2);
    ...
}

To copy to clipboard, switch view to plain text mode 

[adutzu89]

Thank you for your help.