I'm running tcl 8.6.8 on win7x64. I built the latest sqlite Tcl package with the 3310100 source using mingw gcc under msys2.
Everything seems to work but I ran into a strange result with last_insert_rowid(). The following example returns an ever-growing list of rowid's: -----8x----- package require sqlite3 console show #file delete -force test.db sqlite3 sql test.db #sql eval {create table test (id integer primary key, number integer, data blob)} set a [clock seconds] set b [expr {[clock seconds] % 100}] set c [string repeat "\u3456" 25] sql eval { insert into test (id, number, data) values( $a, $b, $c ) } # The next statement returns a list... but shouldn't it only have one element? set oid [sql eval { select last_insert_rowid() from test }] puts "\[[llength $oid]\] $oid" -----8x----- If the "file delete" and "create table" are uncommented, I only get a single rowid the first time of course. I am a complete sql novice so it's likely that it's a user error but I thought I'd ask. PS. I tried the rss feed in thunderbird but all I get is a date and a link to all the author's posts. It would be nice if the message body was included with each message. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users