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