| | @@ -302,10 +302,11 @@ |
| 302 | 302 | "FROM reportfmt WHERE rn=%d",rn); |
| 303 | 303 | style_header("SQL For Report Format Number %d", rn); |
| 304 | 304 | if( db_step(&q)!=SQLITE_ROW ){ |
| 305 | 305 | @ <p>Unknown report number: %d(rn)</p> |
| 306 | 306 | style_footer(); |
| 307 | + db_finalize(&q); |
| 307 | 308 | return; |
| 308 | 309 | } |
| 309 | 310 | zTitle = db_column_text(&q, 0); |
| 310 | 311 | zSQL = db_column_text(&q, 1); |
| 311 | 312 | zOwner = db_column_text(&q, 2); |
| | @@ -323,10 +324,11 @@ |
| 323 | 324 | output_color_key(zClrKey, 0, "border=0 cellspacing=0 cellpadding=3"); |
| 324 | 325 | @ </td> |
| 325 | 326 | @ </tr></table> |
| 326 | 327 | report_format_hints(); |
| 327 | 328 | style_footer(); |
| 329 | + db_finalize(&q); |
| 328 | 330 | } |
| 329 | 331 | |
| 330 | 332 | /* |
| 331 | 333 | ** WEBPAGE: /rptnew |
| 332 | 334 | ** WEBPAGE: /rptedit |
| | @@ -1026,10 +1028,11 @@ |
| 1026 | 1028 | /* view_add_functions(tabs); */ |
| 1027 | 1029 | db_prepare(&q, |
| 1028 | 1030 | "SELECT title, sqlcode, owner, cols FROM reportfmt WHERE rn=%d", rn); |
| 1029 | 1031 | if( db_step(&q)!=SQLITE_ROW ){ |
| 1030 | 1032 | cgi_redirect("reportlist"); |
| 1033 | + db_finalize(&q); |
| 1031 | 1034 | return; |
| 1032 | 1035 | } |
| 1033 | 1036 | zTitle = db_column_malloc(&q, 0); |
| 1034 | 1037 | zSql = db_column_malloc(&q, 1); |
| 1035 | 1038 | zOwner = db_column_malloc(&q, 2); |
| 1036 | 1039 | |