Searched refs:STMT (Results 1 – 25 of 64) sorted by relevance
123
67 set STMT [sqlite3_prepare_v2 $DB {SELECT name FROM sqlite_master} -1 TAIL]68 sqlite3_finalize $STMT82 set STMT [sqlite3_prepare_v2 $DB $sql -1 TAIL]83 sqlite3_finalize $STMT89 set STMT [sqlite3_prepare_v2 $DB $sql -1 TAIL]106 set STMT [sqlite3_prepare16_v2 $DB $sql16 -1 ::TAIL]107 sqlite3_finalize $STMT112 set STMT [sqlite3_prepare16_v2 $DB $sql -1 TAIL]113 sqlite3_finalize $STMT119 set STMT [sqlite3_prepare16_v2 $DB $sql -1 TAIL][all …]
65 set STMT [sqlite3_prepare $DB {SELECT name FROM sqlite_master} -1 TAIL]66 sqlite3_finalize $STMT80 set STMT [sqlite3_prepare $DB $sql -1 TAIL]81 sqlite3_finalize $STMT86 set STMT [sqlite3_prepare $DB $sql [string length $sql] TAIL]87 sqlite3_finalize $STMT92 set STMT [sqlite3_prepare $DB $sql [expr [string length $sql]+1] TAIL]93 sqlite3_finalize $STMT100 set STMT [sqlite3_prepare $DB $sql -1 TAIL]116 set STMT [sqlite3_prepare16 $DB $sql16 -1 ::TAIL][all …]
45 set ::STMT [sqlite3_prepare_v2 $::DB {SELECT * FROM sqlite_master} -1 TAIL]49 sqlite3_step $::STMT52 sqlite3_finalize $::STMT55 set ::STMT [sqlite3_prepare_v2 $::DB {SELECT * FROM sqlite_master} -1 TAIL]59 sqlite3_step $::STMT62 sqlite3_finalize $::STMT68 set ::STMT [sqlite3_prepare_v2 $::DB {SELECT * FROM sqlite_master} -1 TAIL]72 sqlite3_step $::STMT75 sqlite3_finalize $::STMT78 set ::STMT [sqlite3_prepare_v2 $::DB {SELECT * FROM sqlite_master} -1 TAIL][all …]
45 set ::STMT [sqlite3_prepare $::DB {SELECT * FROM sqlite_master} -1 TAIL]49 sqlite3_step $::STMT52 sqlite3_finalize $::STMT55 set ::STMT [sqlite3_prepare $::DB {SELECT * FROM sqlite_master} -1 TAIL]59 sqlite3_step $::STMT62 sqlite3_finalize $::STMT67 set ::STMT [sqlite3_prepare $::DB {SELECT * FROM sqlite_master} -1 TAIL]71 sqlite3_step $::STMT74 sqlite3_finalize $::STMT77 set ::STMT [sqlite3_prepare $::DB {SELECT * FROM sqlite_master} -1 TAIL][all …]
50 set STMT [sqlite3_prepare $DB $sql -1 TAIL]51 sqlite3_step $STMT52 sqlite3_finalize $STMT58 set STMT [sqlite3_prepare $DB $sql -1 TAIL]59 sqlite3_step $STMT60 sqlite3_finalize $STMT62 set STMT [sqlite3_prepare $DB $sql -1 TAIL]63 sqlite3_step $STMT64 sqlite3_finalize $STMT70 set STMT [sqlite3_prepare16 $DB $sql16 -1 TAIL][all …]
49 set STMT [sqlite3_prepare $DB $sql -1 TAIL]50 sqlite3_step $STMT51 sqlite3_finalize $STMT57 set STMT [sqlite3_prepare $DB $sql -1 TAIL]58 sqlite3_step $STMT59 sqlite3_finalize $STMT61 set STMT [sqlite3_prepare $DB $sql -1 TAIL]62 sqlite3_step $STMT63 sqlite3_finalize $STMT69 set STMT [sqlite3_prepare16 $DB $sql16 -1 TAIL][all …]
24 set STMT [sqlite3_prepare $DB {SELECT hex8(?)} -1 DUMMY]27 sqlite_bind $STMT 1 {} static-nbytes28 sqlite3_step $STMT31 sqlite3_column_text $STMT 035 sqlite3_finalize $STMT36 set STMT [sqlite3_prepare $DB {SELECT hex16(?)} -1 DUMMY]39 sqlite_bind $STMT 1 {} static-nbytes40 sqlite3_step $STMT43 sqlite3_column_text $STMT 046 sqlite3_finalize $STMT
38 set ::STMT [sqlite3_prepare db "INSERT INTO t1 VALUES(?)" -1 TAIL]39 sqlite3_bind_double $::STMT 1 NaN40 sqlite3_step $::STMT41 sqlite3_reset $::STMT46 sqlite3_bind_double $::STMT 1 +Inf47 sqlite3_step $::STMT48 sqlite3_reset $::STMT52 sqlite3_bind_double $::STMT 1 -Inf53 sqlite3_step $::STMT54 sqlite3_reset $::STMT[all …]
61 set STMT [sqlite3_prepare db {SELECT x FROM t1} -1 TAIL]62 sqlite3_step $STMT65 sqlite3_column_int $STMT 081 sqlite3_column_int $STMT 084 sqlite3_step $STMT87 sqlite3_column_int $STMT 0101 sqlite3_column_int $STMT 0104 sqlite3_step $STMT107 sqlite3_column_int $STMT 0120 sqlite3_column_int $STMT 0[all …]
21 set STMT [sqlite3_prepare_v2 $DB $SQL -1 TAIL]25 sqlite3_bind_parameter_count $STMT28 sqlite3_bind_int $STMT 1 12329 sqlite3_bind_int $STMT 2 45630 sqlite3_step $STMT31 sqlite3_column_int $STMT 033 sqlite3_finalize $STMT
50 set ::STMT [sqlite3_prepare $::DB $sql -1 TAIL]51 expr [string length $::STMT] > 074 set ::name8 [sqlite3_column_name $::STMT 0]80 set ::name16 [sqlite3_column_name16 $::STMT 0]88 set ::name8_2 [sqlite3_column_name $::STMT 0]109 sqlite3_step $::STMT116 set ::text8 [sqlite3_column_text $::STMT 0]121 set ::text16 [sqlite3_column_text16 $::STMT 0]128 set ::text8_2 [sqlite3_column_text $::STMT 0]139 sqlite3_column_text16 $::STMT 0[all …]
77 set ::STMT [sqlite3_prepare $::DB "SELECT * FROM temp_t1" -1 DUMMY]81 list [sqlite3_step $::STMT] [sqlite3_finalize $::STMT]90 set ::STMT [sqlite3_prepare $::DB "SELECT * FROM temp_v1" -1 DUMMY]94 list [sqlite3_step $::STMT] [sqlite3_finalize $::STMT]102 set ::STMT [sqlite3_prepare $::DB "SELECT * FROM temp_v1" -1 DUMMY]106 list [sqlite3_step $::STMT] [sqlite3_finalize $::STMT]
34 if {[catch {sqlite3_prepare db $sql $sqlbytes TAIL} STMT]} {35 set msg $STMT36 set STMT {}40 if {$STMT!=""} {41 sqlite3_finalize $STMT
164 set ::STMT [sqlite3_prepare $::DB2 "SELECT a FROM t1 ORDER BY a" -1 DUMMY]165 sqlite3_step $::STMT ;# Cursor points at 000.000.000.000166 sqlite3_step $::STMT ;# Cursor points at 001.001.001.001176 set ::steprc [sqlite3_step $::STMT]177 set ::column [sqlite3_column_text $::STMT 0]178 set ::finalrc [sqlite3_finalize $::STMT]191 # statement $::STMT will have been aborted. This means [sqlite3_stmt]243 set ::STMT [sqlite3_prepare $::DB2 \245 sqlite3_step $::STMT ;# Cursor points at 199.199.199.199.199246 sqlite3_step $::STMT ;# Cursor points at 198.198.198.198.198[all …]
38 unset -nocomplain ::STMT41 sqlite3_step $::STMT42 set rc [sqlite3_column_int $::STMT 0]43 sqlite3_reset $::STMT59 set ::STMT [sqlite3_prepare_v2 $DB $sql -1 TAIL]62 # cause all $::STMT to hit an expired cookie. Prior to the fix75 sqlite3_finalize $::STMT
45 set STMT [sqlite3_prepare $DB "SELECT a FROM t1" -1 TAIL]46 sqlite3_step $STMT62 sqlite3_step $STMT67 do_test rollback-1.6 { sqlite3_reset $STMT } {SQLITE_ABORT}69 do_test rollback-1.6 { sqlite3_reset $STMT } {SQLITE_OK}73 sqlite3_step $STMT76 sqlite3_step $STMT79 sqlite3_finalize $STMT
58 set STMT [sqlite3_prepare $DB {INSERT INTO t1 VALUES(2,3)} -1 TAIL]65 sqlite3_step $STMT70 sqlite3_reset $STMT74 sqlite3_step $STMT84 catch {sqlite3_finalize $STMT}128 set STMT [sqlite3_prepare $DB {INSERT INTO t2 VALUES(2,3)} -1 TAIL]135 sqlite3_step $STMT140 sqlite3_reset $STMT144 sqlite3_step $STMT154 catch {sqlite3_finalize $STMT}
223 set ::STMT {}226 set ::STMT [sqlite3_prepare db $sql -1 X]227 sqlite3_step $::STMT235 sqlite3_column_text16 $::STMT 0236 sqlite3_column_int $::STMT 0237 sqlite3_column_text16 $::STMT 1238 sqlite3_column_double $::STMT 1239 set rc [sqlite3_reset $::STMT]241 sqlite3_bind_text16 $::STMT 1 $::bomstr 60242 #catch {sqlite3_finalize $::STMT}[all …]
63 if {$::STMT eq ""} {64 set ::STMT [sqlite3_prepare db2 {SELECT rowid FROM sqlite_master} -1 TAIL]65 set rc [sqlite3_step $::STMT]76 if {$::STMT ne ""} {77 sqlite3_finalize $::STMT78 set ::STMT ""85 set ::STMT ""
38 set STMT [sqlite3_prepare_v2 $db $zSql -1 zSql]39 while {[set rc [sqlite3_step $STMT]] eq "SQLITE_ROW"} { }40 set rc [sqlite3_finalize $STMT]147 set STMT [sqlite3_prepare_v2 $db $zSql -1 zSql]148 while {[set rc [sqlite3_step $STMT]] eq "SQLITE_ROW"} {149 for {set i 0} {$i < [sqlite3_column_count $STMT]} {incr i} {150 lappend lRes [sqlite3_column_text $STMT 0]153 set rc [sqlite3_finalize $STMT]
20 # Return the text values from the current row pointed at by STMT as a list.21 proc get_row_values {STMT} {23 for {set i 0} {$i < [sqlite3_data_count $STMT]} {incr i} {24 lappend VALUES [sqlite3_column_text $STMT $i]30 # of the SQL statement STMT.37 proc get_column_names {STMT} {39 for {set i 0} {$i < [sqlite3_column_count $STMT]} {incr i} {40 lappend VALUES [sqlite3_column_name $STMT $i]42 for {set i 0} {$i < [sqlite3_column_count $STMT]} {incr i} {43 lappend VALUES [sqlite3_column_decltype $STMT $i][all …]
202 set ::STMT [sqlite3_prepare $::DB "SELECT length(?)" -1 DUMMY]204 sqlite3_bind_zeroblob $::STMT 1 450000205 sqlite3_step $::STMT208 sqlite3_column_int $::STMT 0211 sqlite3_finalize $::STMT
132 set STMT [sqlite3_prepare $DB "DELETE FROM t1 WHERE a = ?" -1 DUMMY]133 sqlite3_bind_blob $STMT 1 "\x12\x34\x56" 3134 sqlite3_step $STMT137 sqlite3_finalize $STMT
98 set STMT [sqlite3_prepare $DB {%s} -1 TAIL]99 set rc [sqlite3_stmt_readonly $STMT]100 sqlite3_finalize $STMT