Re: [sqlite] Re: creating own pragmas

2006-12-07 Thread Günter Greschenz
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

Re: [sqlite] Re: creating own pragmas

2006-12-07 Thread Christian Smith
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

Re: [sqlite] Re: creating own pragmas

2006-12-01 Thread Dennis Cote
Günter Greschenz wrote: hi, i implemented crypting for values: insert into test (x, y, z) values(encrypt('this is a test', 'pwd'), 'foo', 'bar') insert into test (x, y, z) values(encrypt('this is test 2', 'pwd'), 'foo2', 'bar2') ... select decrypt(x, 'pwd') x, y, z from test

Re: [sqlite] Re: creating own pragmas

2006-12-01 Thread Günter Greschenz
hi, i implemented crypting for values: insert into test (x, y, z) values(encrypt('this is a test', 'pwd'), 'foo', 'bar') insert into test (x, y, z) values(encrypt('this is test 2', 'pwd'), 'foo2', 'bar2') ... select decrypt(x, 'pwd') x, y, z from test where decrypt(x, 'pwd')

[sqlite] Re: creating own pragmas

2006-12-01 Thread Igor Tandetnik
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