Re: [sqlite] Boolean values in variable, tclsqlite3

2019-07-19 Thread Simon Slavin
On 19 Jul 2019, at 9:15pm, Gilles Pérez wrote: > Is it possible in Tcl to specify I want a boolean? You don't want a boolean. SQLite doesn't understand booleans. You want integers. Do this Constants: DB_FALSE = 0, DB_TRUE = 1 I would suggest you don't use names like SQLITE_FALSE be

Re: [sqlite] Boolean values in variable, tclsqlite3

2019-07-19 Thread Gilles Pérez
2019-07-19 19:29 +02:00, d...@sqlite.org : > On 7/19/19, Gilles Pérez wrote: > > set tvalue true > > This statement sets the TCL variable "tvalue" to the four-character > string "true", not to a boolean true. Is it possible in Tcl to specify I want a boolean? For now, I “filter” true/false

Re: [sqlite] Boolean values in variable, tclsqlite3

2019-07-19 Thread Richard Hipp
On 7/19/19, Gilles Pérez wrote: > set tvalue true This statement sets the TCL variable "tvalue" to the four-character string "true", not to a boolean true. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists

Re: [sqlite] Boolean values in variable, tclsqlite3

2019-07-19 Thread Gilles Pérez
As the script got removed, here it is: package require sqlite3 proc main {} { puts "sqlite3 version: [ exec sqlite3 -version ]" sqlite3 db :memory: puts "libsqlite3 version: [ db version ]" db eval {