QSqlRecord double precision

[DavidBell]

I am accessing data from an SQLite database created in another application (SQLiteStudio) that has a field that contains a double.

It all works ok except that I am only getting six significant digits (ie float) whereas the file In SQLiteStudio it has 11 significant digits.

Any help appreciated, need full precision for this case.

Code snip folows
David Bell

QSqlQuery getTreesquery(dbsrc); 
getTreesquery.setNumericalPrecisionPolicy(QSql::HighPrecision); // database precision also set to high
 
getTreesquery.exec("SELECT * FROM Objects WHERE yada yada");
 
while (getTreesquery.next())
      {
        double gpsLatitude = getTreesquery.record().value(eGOF_LATITUDE).toDouble(); // only six digits
      }

QSqlQuery getTreesquery(dbsrc); 
getTreesquery.setNumericalPrecisionPolicy(QSql::HighPrecision); // database precision also set to high

getTreesquery.exec("SELECT * FROM Objects WHERE yada yada");

while (getTreesquery.next())
      {
        double gpsLatitude = getTreesquery.record().value(eGOF_LATITUDE).toDouble(); // only six digits
      }

To copy to clipboard, switch view to plain text mode 

[DavidBell]

My mistake, I was using QString::number to build and INSERT command to put the value into a second database. Both QString::number & qDebug have default precision = 6.