Changeset 19

Timestamp:

10/16/08 19:30:58 (16 years ago)

Author:

ahe

Message:

update cbr_search in cbr.c

Files:

• vtcross/trunk/src/cbr.c (modified) (3 diffs)

vtcross/trunk/src/cbr.c

@@ -124 +124 @@
     ExecuteCommand(_cbr);
 
+    // clean the database
+    strcpy(_cbr->command, "vacuum");
+    ExecuteCommand(_cbr);
+
     free(_cbr);
 }
@@ -129 +133 @@
 void cbr_print(cbr _cbr)
 {
-    // generate command
-    strcpy(_cbr->command, "select * from ");
+    // generate commandi
+    strcpy(_cbr->command, "select ");
+    strcat(_cbr->command, _cbr->tablename);
+    strcat(_cbr->command, ".* from ");
     strcat(_cbr->command, _cbr->tablename);
     strcat(_cbr->command, ";");
@@ -149 +155 @@
     // set up statement
 
-    char* zErrMsg = NULL;
+    /*char* zErrMsg = NULL;
     //sqlite3_exec(_cbr->db, argv[2], callback, NULL, &zErrMsg);
-    sqlite3_exec(_cbr->db, _cbr->command, cbr_callback, NULL, &zErrMsg);
+    sqlite3_exec(_cbr->db, _cbr->command, cbr_callback, NULL, &zErrMsg);*/
+
+    // generate command
+    strcpy(_cbr->command, "select ");
+    strcat(_cbr->command, _cbr->tablename);
+    strcat(_cbr->command, ".* from ");
+    strcat(_cbr->command, _cbr->tablename);
+    strcat(_cbr->command, " where ");
 
     return 0;