Do not ask for EPSG ID, it is not in custom projections anyway.

homann · homann · commit e7a68ba0d79d · 2008-09-18T10:13:33.000Z
git-svn-id: http://svn.osgeo.org/qgis/trunk@9348 c8812cc2-4d05-0410-92ff-de0c093fc19c
diff --git a/src/gui/qgsprojectionselector.cpp b/src/gui/qgsprojectionselector.cpp
@@ -529,7 +529,7 @@ void QgsProjectionSelector::loadUserCrsList( QSet<QString> * crsFilter )
   }
 
   // Set up the query to retrieve the projection information needed to populate the list
-  QString mySql = "select description, srs_id, epsg, is_geo, name, parameters from vw_srs ";
+  QString mySql = "select description, srs_id from vw_srs ";
   mySql += "where ";
   mySql += sqlFilter;
 
@@ -541,8 +541,10 @@ void QgsProjectionSelector::loadUserCrsList( QSet<QString> * crsFilter )
     while ( sqlite3_step( myPreparedStatement ) == SQLITE_ROW )
     {
       newItem = new QTreeWidgetItem( mUserProjList, QStringList( QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 0 ) ) ) );
+      // EPSG for user projections is not always defined in some dbases.
+      // It's also not written from customprojections dialog.
       // display the epsg (field 2) in the second column of the list view
-      newItem->setText( EPSG_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 2 ) ) );
+      // newItem->setText( EPSG_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 2 ) ) );
       // display the qgis srs_id (field 1) in the third column of the list view
       newItem->setText( QGIS_CRS_ID_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 1 ) ) );
     }

Original file line number	Diff line number	Diff line change
`@@ -529,7 +529,7 @@ void QgsProjectionSelector::loadUserCrsList( QSet<QString> * crsFilter )`
`529`	`529`	`}`
`530`	`530`
`531`	`531`	`// Set up the query to retrieve the projection information needed to populate the list`
`532`		`- QString mySql = "select description, srs_id, epsg, is_geo, name, parameters from vw_srs ";`
	`532`	`+ QString mySql = "select description, srs_id from vw_srs ";`
`533`	`533`	`mySql += "where ";`
`534`	`534`	`mySql += sqlFilter;`
`535`	`535`
`@@ -541,8 +541,10 @@ void QgsProjectionSelector::loadUserCrsList( QSet<QString> * crsFilter )`
`541`	`541`	`while ( sqlite3_step( myPreparedStatement ) == SQLITE_ROW )`
`542`	`542`	`{`
`543`	`543`	`newItem = new QTreeWidgetItem( mUserProjList, QStringList( QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 0 ) ) ) );`
	`544`	`+ // EPSG for user projections is not always defined in some dbases.`
	`545`	`+ // It's also not written from customprojections dialog.`
`544`	`546`	`// display the epsg (field 2) in the second column of the list view`
`545`		`- newItem->setText( EPSG_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 2 ) ) );`
	`547`	`+ // newItem->setText( EPSG_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 2 ) ) );`
`546`	`548`	`// display the qgis srs_id (field 1) in the third column of the list view`
`547`	`549`	`newItem->setText( QGIS_CRS_ID_COLUMN, QString::fromUtf8(( char * )sqlite3_column_text( myPreparedStatement, 1 ) ) );`
`548`	`550`	`}`