Taking DRH's remarks about learning tclsqlite for the efficient coding to heart, I discovered a big problem.
Here is the simplest example from the docs and DRH presentation: TCLSH % db function myhex {format 0x%X}; % db eval {select myhex(10);} x {parray x}; x(*) = myhex(10) x(myhex(10)) = 0xA Now, on the same database with simultaneous connection eg: shell, odbc, etc: sqlite> select myhex(10); Run Time: real 0.000 user 0.000000 sys 0.000000 Error: no such function: myhex ----------------------------------------------------------------------------- Did I missing something in the docs? Is there a trick/pragma to make this work? Tclsqlite is extremely efficiently for extending sqlite but this facility is generally useless if the whole application must be ported to (or at least all db queries funneled through) TCLSH to use those easy to build extensions. What if the outer application can't be ported to TCL? Is there another way, like preloading TCL code on the ODBC connection? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users