Thanks, i will go through it. regrads ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email 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 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 call one of the sqlite3_result_* > functions (see > http://www.sqlite.org/capi3ref.html#sqlite3_result_blob). > For a boolean result you would use sqlite3_result_integer and > return a > value of 1 for true or 0 for false. > > For more information see section 2.3 of > http://www.sqlite.org/capi3.html > and the func.c source file at > http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c&v=1.174 > which > uses these APIs to implement all the built in SQL functions. > > HTH > Dennis Cote > > > -------------------------------------------------------------------- > --------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------- > --------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
