QString to double without exponential

[binio]

I want to write "8989898.89" from a lineedit to my database. I use the code:

double databasevar=0;
databasevar = ui->lineEdit_input->text().toDouble();
...
sql insert ...
...

double databasevar=0;
databasevar = ui->lineEdit_input->text().toDouble();
...
sql insert ...
...

To copy to clipboard, switch view to plain text mode 

after the insert i have in my database the value "8989900.00" -> "8.9899e+06".
how do i deactivate the exponential translation that kills the last digits.

Can someone help me pls

[amleto]

you're probably doing something wrong that you are not showing us. Read my sig.

if __name__ == '__main__':
  app = QApplication(sys.argv)
 
  le = QLineEdit()
  le.show()
 
  btn = QPushButton("click")
  btn.show()
  def printText():
    print le.text()
    print float(le.text())
 
  btn.clicked.connect(printText)
  app.exec_()

if __name__ == '__main__':
  app = QApplication(sys.argv)

  le = QLineEdit()
  le.show()

  btn = QPushButton("click")
  btn.show()
  def printText():
    print le.text()
    print float(le.text())

  btn.clicked.connect(printText)
  app.exec_()

To copy to clipboard, switch view to plain text mode 

898989.55
898989.55

898989.55
898989.55

To copy to clipboard, switch view to plain text mode 

[toufic.dbouk]

double d;
d = QString( "1234.56e-02" ).toDouble();
qDebug() << d;

double d;
d = QString( "1234.56e-02" ).toDouble();
qDebug() << d;

To copy to clipboard, switch view to plain text mode 

This should give : 12.3456
So whats your problem exactly ?

[MarekR22]

Problem is that you think that it is a database problem. Database doesn't store the format of number it stores the value (and type of column of course).
Your code should handle proper number formatting when you are display that value from database. For example:

double x = 123423.3;
QString toDisplay = QString::number(x, 'f', 1);

double x = 123423.3;
QString toDisplay = QString::number(x, 'f', 1);

To copy to clipboard, switch view to plain text mode 

[binio]

Database value 123456.78
my code to read the value

bool Vertrag_h::sql_get(QString vertragID){
  QSqlQuery q;
  q.exec(QString("SELECT * FROM vertrag WHERE vertragid='%1' LIMIT 1").arg(vertragID));
  if(!q.isActive()){
    qDebug() << "SQL Error:"+q.lastError().text();
    return 0;
  }else{
      if(q.size()>0){
          while(q.next()){
              this->vertragid = q.value(0).toString();
              this->kaufpreis1 = q.value(1).toDouble();
          }
          return 1;
      }else{
          return 0;
      }
  }
}
 
bool Vertrag_h::sql_set(){
  QSqlQuery q;
  q.exec(QString("UPDATE Vertrag_h SET kaufpreis1='%2' WHERE vertragid='%1'").arg(this->vertragid).arg(this->kaufpreis1));
  if(!q.isActive()){
    qDebug() << "SQL Error:"+q.lastError().text();
    return 0;
  }else{
    return 1;
  }
}

bool Vertrag_h::sql_get(QString vertragID){
  QSqlQuery q;
  q.exec(QString("SELECT * FROM vertrag WHERE vertragid='%1' LIMIT 1").arg(vertragID));
  if(!q.isActive()){
    qDebug() << "SQL Error:"+q.lastError().text();
    return 0;
  }else{
      if(q.size()>0){
          while(q.next()){
              this->vertragid = q.value(0).toString();
              this->kaufpreis1 = q.value(1).toDouble();
          }
          return 1;
      }else{
          return 0;
      }
  }
}

bool Vertrag_h::sql_set(){
  QSqlQuery q;
  q.exec(QString("UPDATE Vertrag_h SET kaufpreis1='%2' WHERE vertragid='%1'").arg(this->vertragid).arg(this->kaufpreis1));
  if(!q.isActive()){
    qDebug() << "SQL Error:"+q.lastError().text();
    return 0;
  }else{
    return 1;
  }
}

To copy to clipboard, switch view to plain text mode 

and i lost my last digits.

[MarekR22]

What is type of your `kaufpreis1` column? Looks like it is a TEXT not a DECIMAL or FLOAT (your query proves that, you have apostrophes there).
So when you put values into database you are loosing precision by default conversion to string and then you are fetching string value which is converted to double.

edit:
now I see that it is even worse! Never ever put data into query like this (this way you are vulnerable for SQL injection).
Read this.

[Lesiok]

First of all no database does not guarantee the immutable order of the data by the query SELECT * FROM ...
Use an explicit specification of columns and then you can safely use the number of columns in the result or read data using column names.

[Ahmed Abdellatif]

Searching for that problem, i have found the following 2 links that will be helpful for those who will search about this in the future :
1. From QT help :

[static] QString QString::number(double n, char format = 'g', int precision = 6)

[static] QString QString::number(double n, char format = 'g', int precision = 6)

To copy to clipboard, switch view to plain text mode 

Returns a string equivalent of the number n, formatted according to the specified format and precision. See Argument Formats for details.

2. http://doc.qt.io/qt-5/qstring.html#argument-formats.
Read them carefully, i think it is adequate