author | Don Pellegrino <don@drexel.edu> | 2009-06-17 18:02:19 (GMT) |
---|---|---|
committer | Don Pellegrino <don@drexel.edu> | 2009-06-17 18:02:19 (GMT) |
commit | eefb241d402dbb40716e3f00eb66997774473741 (patch) (unidiff) | |
tree | ff9f2cc4bae8d20fc4a63ad882e772bebbfa37bd | |
parent | d2d6dbcd7cce68b96c314dabe6f6fc9fd8990704 (diff) | |
download | exp005-eefb241d402dbb40716e3f00eb66997774473741.zip exp005-eefb241d402dbb40716e3f00eb66997774473741.tar.gz exp005-eefb241d402dbb40716e3f00eb66997774473741.tar.bz2 |
Renamed selection_to_db to selsave to reduce the filename to eight
characters. This is necessary due to the limitation of the package
name in DB2 for the binding. It will conflict with selection_from_db otherwise.
-rw-r--r-- | src/controller/selection_to_db.sqc | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/src/controller/selection_to_db.sqc b/src/controller/selection_to_db.sqc deleted file mode 100644 index 0d7de7f..0000000 --- a/src/controller/selection_to_db.sqc +++ b/dev/null | |||
@@ -1,41 +0,0 @@ | |||
1 | #include "selection_to_db.h" | ||
2 | #include "../view/exp004state0.h" | ||
3 | #include <string.h> | ||
4 | #include "../util/check_error.h" | ||
5 | #include "sqlca.h" | ||
6 | extern struct sqlca sqlca; | ||
7 | |||
8 | /* | ||
9 | * A simple alias to make the code more readable. | ||
10 | */ | ||
11 | #define S exp004state0 | ||
12 | |||
13 | void | ||
14 | selection_to_db (void) | ||
15 | { | ||
16 | EXEC SQL BEGIN DECLARE SECTION; | ||
17 | char gi[255]; | ||
18 | EXEC SQL END DECLARE SECTION; | ||
19 | |||
20 | /* | ||
21 | * WHERE gi IS NOT NULL is added to prevent the PRECOMPILE command | ||
22 | * from throwing a warning about modifying an entire table. Since | ||
23 | * gi is defined as NOT NULL this will clear the entire table. | ||
24 | */ | ||
25 | EXEC SQL DELETE FROM vis_selection WHERE gi IS NOT NULL; | ||
26 | check_error (__FILE__, __LINE__); | ||
27 | |||
28 | for (unsigned int i = 0; i < ROWS; i++) | ||
29 | { | ||
30 | if (S.selection[i] == true) | ||
31 | { | ||
32 | strncpy (gi, S.gi_data[i] + 3, sizeof(gi)); | ||
33 | EXEC SQL INSERT INTO vis_selection VALUES (:gi); | ||
34 | } | ||
35 | } | ||
36 | |||
37 | EXEC SQL COMMIT; | ||
38 | check_error (__FILE__, __LINE__); | ||
39 | |||
40 | return; | ||
41 | } | ||