Re: [sqlite] Re: Re: Merging two tables

2007-09-10 Thread RaghavendraK 70574
immediately and delete it! * - Original Message - From: Dennis Cote <[EMAIL PROTECTED]> Date: Tuesday, September 11, 2007 4:39 am Subject: Re: [sqlite] Re: Re: Merging two tables > RaghavendraK 70

Re: [sqlite] Re: Re: Merging two tables

2007-09-10 Thread Dennis Cote
RaghavendraK 70574 wrote: In sqlite3_create_function, xFunc func pointer signature does not allow to have a return value.Any other possible way achieving it apart from collation? The result of your custom function is not returned directly by the xFunc function. your xFunc function must

Re: [sqlite] Re: Re: Merging two tables

2007-09-08 Thread RaghavendraK 70574
AIL PROTECTED]> Date: Wednesday, September 5, 2007 8:50 pm Subject: [sqlite] Re: Re: Merging two tables > RaghavendraK 70574 > <[EMAIL PROTECTED]> wrote: > >> How to plug custom search algorthim within Sqlite? > >> For example, > >> > >> select *

Re: [sqlite] Re: Re: Merging two tables

2007-09-05 Thread John Stanton
it! * - Original Message - From: Igor Tandetnik <[EMAIL PROTECTED]> Date: Wednesday, September 5, 2007 6:20 pm Subject: [sqlite] Re: Re: Merging two tables RaghavendraK 70574 <[EMAIL PROTECTED]>

Re: [sqlite] Re: Re: Merging two tables

2007-09-05 Thread Scott Derrick
- Original Message - From: Igor Tandetnik <[EMAIL PROTECTED]> Date: Wednesday, September 5, 2007 6:20 pm Subject: [sqlite] Re: Re: Merging two tables RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: How to plug custom search algorthim within Sqlite? For example, select * fro

Re: [sqlite] Re: Re: Merging two tables

2007-09-05 Thread RaghavendraK 70574
nesday, September 5, 2007 6:20 pm Subject: [sqlite] Re: Re: Merging two tables > RaghavendraK 70574 > <[EMAIL PROTECTED]> wrote: > >> How to plug custom search algorthim within Sqlite? > >> For example, > >> > >> select * from table where a = 'xxx'

[sqlite] Re: Re: Merging two tables

2007-09-05 Thread Igor Tandetnik
RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: How to plug custom search algorthim within Sqlite? For example, select * from table where a = 'xxx'; Instead of using normal inbuilt search can it be userDefined function? Yes. You can use sqlite3_create_function to create a function taking two