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
