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
Hi, 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? regards ragha ** This email and its attachments

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

2007-09-05 Thread John Stanton
Look in the Sqlite source for examples. Your function gets the arguments you specify in the SQL and then your program does whatever you like with them and returns a result. It could for example perform a regular expression compare etc. You register the function with Sqlite when you open a

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

2007-09-05 Thread Scott Derrick
How can this be used to "Merge two tables"? Scott RaghavendraK 70574 wrote: Thats great. If possible Can u please provide a sample, Will this function receive the database column values or indexes? regards ragha

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

2007-09-05 Thread RaghavendraK 70574
Thats great. If possible Can u please provide a sample, Will this function receive the database column values or indexes? regards ragha ** This email and its attachments contain confidential information