** Toggle the reverse_unordered_selects setting. */
| 13835 | ** Toggle the reverse_unordered_selects setting. |
| 13836 | */ |
| 13837 | static void toggleSelectOrder(sqlite3 *db){ |
| 13838 | sqlite3_stmt *pStmt = 0; |
| 13839 | int iSetting = 0; |
| 13840 | char zStmt[100]; |
| 13841 | sqlite3_prepare_v2(db, "PRAGMA reverse_unordered_selects", -1, &pStmt, 0); |
| 13842 | if( sqlite3_step(pStmt)==SQLITE_ROW ){ |
| 13843 | iSetting = sqlite3_column_int(pStmt, 0); |
| 13844 | } |
| 13845 | sqlite3_finalize(pStmt); |
| 13846 | sqlite3_snprintf(sizeof(zStmt), zStmt, |
| 13847 | "PRAGMA reverse_unordered_selects(%d)", !iSetting); |
| 13848 | sqlite3_exec(db, zStmt, 0, 0, 0); |
| 13849 | } |
| 13850 | |
| 13851 | /* |
| 13852 | ** This is a different callback routine used for dumping the database. |