Hmmmmm... I sent this message last night as a non-list member. I
received a notification that it would need to be approved by a moderator
before being made public. About 15 hours later, I received a "Post was
rejected... No reason given" message. Why's that? So now I'm
subscribed again. Anyway...
==============================
Hi All,
I am upgrading a Tcl/SQLite based application from SQLite 3.4.2 to
SQLite 3.5.9. I'll mention that I'm also upgrading from Tcl 8.4.19 to
Tcl 8.5.2 in case it's relevant, though both versions of Tcl behave the
same when using SQLite 3.5.9.
Anyway, I have a number of procedures that operate like the following:
dbMem eval {select distinct(owner) from lockinfo order by owner} {
<do something with $owner>
}
That works correctly in my original app using 3.4.2, but complains that
there is no such variable "owner" when using 3.5.9. Interestingly, I've
found that the above code works under 3.5.2 when not inside a Tcl
procedure. Inside the procedure though, it breaks as described. Also,
a few other variations...
Inside a procedure, using 3.5.2, replacing "distinct(owner)" with just
"owner" works correctly and replacing "distinct(owner) with just "*"
works correctly, though neither obviously does what I need.
Is this an intended change to SQLite Tcl bindings, a bug, or just
something else I'm missing?
Thanks for any insight.
Jeff Godfrey
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
