Christian Smith schrieb:
Dennis Cote uttered:

Igor Tandetnik schrieb:
G�nter Greschenz <[EMAIL PROTECTED]> wrote:
i'm using "sqlite3_create_function()" to create own functions in my
database.
this is a really nice possibility to extend the database with powerful
functions.
but i did not find a way to create own pragmas like "pragma foo=bar"
to pass some global information to my application.

Pass global information from where? Why would your application use such
a roundabout way to pass global information to itself? If you need to
store some global settings in the database, why not just create a table
for them?

Gunter,

Igor is right, you should store your password in a table. If you are concerned about the password being saved in the database, then you could use a temporary table, or even attach a :memory: database to hold the table that contains the password. In any case the saved password is available to your encrypt and decrypt functions.


Or, even define a custom function to set the password:
SELECT set_password('password');

yes, sounds like a portable solution.
until now i patched the pragma-code (was just 3 lines), because i think its much more elegant to use,
but to avoid sqlite-source-ipdate-problems, i'll implement this too.
thanks !


HTH
Dennis Cote


Christian


--
    /"\
    \ /    ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
     X                           - AGAINST MS ATTACHMENTS
    / \
------------------------------------------------------------------------

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to