Lines Matching refs:sSelect

4207     ShellText sSelect;  local
4239     initText(&sSelect);
4240     appendText(&sSelect, "SELECT ", 0);
4242       appendText(&sSelect, azCol[0], 0);
4243       appendText(&sSelect, ",", 0);
4246       appendText(&sSelect, azCol[i], quoteChar(azCol[i]));
4248         appendText(&sSelect, ",", 0);
4252     appendText(&sSelect, " FROM ", 0);
4253     appendText(&sSelect, zTable, quoteChar(zTable));
4259     rc = shell_exec(p, sSelect.z, 0);
4263       shell_exec(p, sSelect.z, 0);
4269     freeText(&sSelect);
9538     ShellText sSelect;  local
9552     initText(&sSelect);
9605       appendText(&sSelect, "SELECT sql FROM", 0);
9611         appendText(&sSelect, zDiv, 0);
9613         appendText(&sSelect, "SELECT shell_add_schema(sql,", 0);
9615           appendText(&sSelect, zDb, '\'');
9617           appendText(&sSelect, "NULL", 0);
9619         appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
9620         appendText(&sSelect, zScNum, 0);
9621         appendText(&sSelect, " AS snum, ", 0);
9622         appendText(&sSelect, zDb, '\'');
9623         appendText(&sSelect, " AS sname FROM ", 0);
9624         appendText(&sSelect, zDb, quoteChar(zDb));
9625         appendText(&sSelect, ".sqlite_schema", 0);
9630         appendText(&sSelect,
9636       appendText(&sSelect, ") WHERE ", 0);
9644           appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0);
9646           appendText(&sSelect, "lower(tbl_name)", 0);
9648         appendText(&sSelect, bGlob ? " GLOB " : " LIKE ", 0);
9649         appendText(&sSelect, zQarg, 0);
9651           appendText(&sSelect, " ESCAPE '\\' ", 0);
9653         appendText(&sSelect, " AND ", 0);
9657         appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0);
9659       appendText(&sSelect, "sql IS NOT NULL"
9662         utf8_printf(p->out, "SQL: %s;\n", sSelect.z);
9664         rc = sqlite3_exec(p->db, sSelect.z, callback, &data, &zErrMsg);
9666       freeText(&sSelect);