Lines Matching refs:S

388   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE b>?" -1 dummy]
389   sqlite3_expired $S
392   sqlite3_bind_text $S 1 "abc" 3
393   sqlite3_expired $S
396   sqlite3_finalize $S
400   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE b=?" -1 dummy]
401   sqlite3_expired $S
404   sqlite3_bind_text $S 1 "abc" 3
405   sqlite3_expired $S
408   sqlite3_finalize $S
412   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE a=? AND b>?" -1 dummy]
413   sqlite3_expired $S
416   sqlite3_bind_text $S 1 "abc" 3
417   sqlite3_expired $S
420   sqlite3_bind_text $S 2 "def" 3
421   sqlite3_expired $S
424   sqlite3_bind_text $S 2 "ghi" 3
425   sqlite3_expired $S
428   sqlite3_expired $S
431   sqlite3_finalize $S
435   set S [sqlite3_prepare_v2 db {
442   sqlite3_expired $S
445   sqlite3_bind_text $S 31 "abc" 3
446   sqlite3_expired $S
449   sqlite3_bind_text $S 32 "def" 3
450   sqlite3_expired $S
453   sqlite3_finalize $S
457   set S [sqlite3_prepare_v2 db {
464   sqlite3_expired $S
467   sqlite3_bind_text $S 32 "abc" 3
468   sqlite3_expired $S
471   sqlite3_bind_text $S 33 "def" 3
472   sqlite3_expired $S
475   sqlite3_finalize $S
479   set S [sqlite3_prepare_v2 db {
486   sqlite3_expired $S
489   sqlite3_bind_text $S 32 "abc" 3
490   sqlite3_expired $S
493   sqlite3_bind_text $S 33 "def" 3
494   sqlite3_expired $S
497   sqlite3_bind_text $S 10 "def" 3
498   sqlite3_expired $S
501   sqlite3_finalize $S
511   set S [sqlite3_prepare_v2 db {
514   sqlite3_expired $S
517   sqlite3_bind_text $S 1 "abc" 3
518   sqlite3_expired $S
521   sqlite3_bind_text $S 2 "def" 3
522   sqlite3_expired $S
525   sqlite3_bind_text $S 2 "ghi%" 4
526   sqlite3_expired $S
529   sqlite3_expired $S
532   sqlite3_bind_text $S 2 "ghi%def" 7
533   sqlite3_expired $S
536   sqlite3_expired $S
539   sqlite3_bind_text $S 2 "%ab" 3
540   sqlite3_expired $S
543   sqlite3_expired $S
546   sqlite3_bind_text $S 2 "%de" 3
547   sqlite3_expired $S
550   sqlite3_expired $S
553   sqlite3_finalize $S
564   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE a=? AND b>?" -1 dummy]
565   sqlite3_step $S
568   sqlite3_reset $S
569   sqlite3_bind_text $S 2 "abc" 3
571   sqlite3_step $S
574   sqlite3_finalize $S
590   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE a=? AND b>?" -1 dummy]
591   sqlite3_step $S
599   sqlite3_reset $S
600   sqlite3_bind_text $S 2 "abc" 3
601   sqlite3_step $S
604   sqlite3_finalize $S
613   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE a=? AND b>?" -1 dummy]
616   sqlite3_step $S
619   sqlite3_finalize $S
643   set S [sqlite3_prepare_v2 db "SELECT * FROM t1 WHERE x LIKE ?" -1 dummy]
644   sqlite3_bind_text $S 1 "a%" 2
646   while { "SQLITE_ROW" == [sqlite3_step $S] } {
647     lappend R [sqlite3_column_text $S 0]
649   concat [sqlite3_reset $S] $R
652   sqlite3_clear_bindings $S
654   while { "SQLITE_ROW" == [sqlite3_step $S] } {
655     lappend R [sqlite3_column_text $S 0]
657   concat [sqlite3_reset $S] $R
660   sqlite3_finalize $S