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]
-----------------------------------------------------------------------------