Thanks, that explains what I saw.
What I was trying to accomplish was retrieve the autoincrement key for
the row that had just been previously inserted. I missed the
"last_insert_rowid" method in the docs for the Tcl Sqlite interface --
it's only 3 lines :-)
On 2/17/20, The Tick wrote:
> sql eval { insert into test (id, number, data) values( $a, $b, $c ) }
What were you hoping to accomplish here? It seems like you might be
wanting the rowid of the last insert by any database connection into
the "test" table. If so, that is not what last_insert_rowi
On Monday, 17 February, 2020 17:20, The Tick wrote:
>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
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 req
4 matches
Mail list logo