Hi All,
In my example code here the function "fun" is called twice for each row. The
first set of calls is made in the initial evaluation of the sql statement, then
"fun" is called again as the tcl body is evaluated for each row. I wasn't
expecting this.
Thanks,
John
------------------------
lappend auto_path /home/john/lib
package require sqlite3
sqlite3 db data.db
proc fun {} {
puts "Fun Called"
incr ::count
}
db function fun fun
db eval { select distinct *, fun() as H from T } T { puts "$T(x), $T(H)" }
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
