Lines Matching defs:sSelect

22634     ShellText sSelect;
22666     initText(&sSelect);
22667     appendText(&sSelect, "SELECT ", 0);
22669       appendText(&sSelect, azCol[0], 0);
22670       appendText(&sSelect, ",", 0);
22673       appendText(&sSelect, azCol[i], quoteChar(azCol[i]));
22675         appendText(&sSelect, ",", 0);
22679     appendText(&sSelect, " FROM ", 0);
22680     appendText(&sSelect, zTable, quoteChar(zTable));
22686     rc = shell_exec(p, sSelect.z, 0);
22690       shell_exec(p, sSelect.z, 0);
22696     freeText(&sSelect);
28105     ShellText sSelect;
28119     initText(&sSelect);
28172       appendText(&sSelect, "SELECT sql FROM", 0);
28178         appendText(&sSelect, zDiv, 0);
28180         appendText(&sSelect, "SELECT shell_add_schema(sql,", 0);
28182           appendText(&sSelect, zDb, '\'');
28184           appendText(&sSelect, "NULL", 0);
28186         appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
28187         appendText(&sSelect, zScNum, 0);
28188         appendText(&sSelect, " AS snum, ", 0);
28189         appendText(&sSelect, zDb, '\'');
28190         appendText(&sSelect, " AS sname FROM ", 0);
28191         appendText(&sSelect, zDb, quoteChar(zDb));
28192         appendText(&sSelect, ".sqlite_schema", 0);
28197         appendText(&sSelect,
28203       appendText(&sSelect, ") WHERE ", 0);
28211           appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0);
28213           appendText(&sSelect, "lower(tbl_name)", 0);
28215         appendText(&sSelect, bGlob ? " GLOB " : " LIKE ", 0);
28216         appendText(&sSelect, zQarg, 0);
28218           appendText(&sSelect, " ESCAPE '\\' ", 0);
28220         appendText(&sSelect, " AND ", 0);
28224         appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0);
28226       appendText(&sSelect, "sql IS NOT NULL"
28229         oputf("SQL: %s;\n", sSelect.z);
28231         rc = sqlite3_exec(p->db, sSelect.z, callback, &data, &zErrMsg);
28233       freeText(&sSelect);