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');
HTH
Dennis Cote
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------