Julien,
Thanks for the pointer. That does indeed look interesting, though I'm
not sure it completely solves my problem (though, there may be no good
solution to my problem). It would seem that, using the "loadable
extension" feature, I could easily create a compiled version of my
necessary "power" function. Further, it would seem my new function
could be loaded via a SQL statement, which *might* make it available
in a 3rd party GUI package that's compiled with the standard SQLite
library. That said, there seems to be one potential hiccup...
According to the mentioned docs, this functionality is turned *off* by
default in the library, as there are some potential security concerns.
So, unless the 3rd party tool is compiled with this functionality
turned *on*, I don't see that I could load my function there anyway.
There may be other things that would prevent me from loading an
external function into a 3rd party app also - I don't know.
So, I've opened a discussion with the author of my chosen SQLite GUI
tool (SQLite Expert Personal) to see what my options are. Anyway,
thanks for pointing me to another possible option. As I said earlier,
I'm very new to SQLite. Most of my database work (though not
extensive anyway) has been with commercial packages (MS Access,
Oracle, SQL Server, etc). In those environments (generally), since
the package already *has* a GUI-based management tool built-in, any
custom SQL functions that are created are accessible to the GUI tool
by default.
In the case of SQLite, I (arguably) have to use a 3rd party management
tool, for which my custom functions are no longer available. I'm
curious how others handle this.
A. You don't need or use any custom SQL functionality
B. You don't use a 3rd party SQLite management tool
C. Something else I haven't thought of?
Thanks for any additional guidance.
Jeff Godfrey
----- Original Message -----
From: "jt" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, December 20, 2006 9:23 AM
Subject: Re: [sqlite] Mathematical "power" operator?
Hi,
Look at the new "loadable extension" feature:
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
It also describe an example that could be really easy to convert to
your sqrt problem.
--
Julien
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
