Re: [sqlite] WHERE with user function
On 7/28/06, Stan <[EMAIL PROTECTED]> wrote: Is there any example (tutorial or explanation) in C or C++ for similar problem? Stan, All the built in functions in sqlite use exactly the same API that is available to you. The source file func.c conatins many examples of user defined functions and returning values from these functions. You can view the file here http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c=1.132 or download one of the source packages at http://www.sqlite.org/download.html. HTH Dennis Cote
Re: [sqlite] WHERE with user function
Stan uttered: Hi, I need user function for WHERE clause. But I don't know what type of parameters to use for such function: SELECT * FROM Table WHERE MYFUNC(ColumnName, IntValue). Above all - how to returm value to WHERE and what type? Is there any example (tutorial or explanation) in C or C++ for similar problem? You've checked out the API reference? http://www.sqlite.org/capi3ref.html#sqlite3_create_function Thanks Stan -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
[sqlite] WHERE with user function
Hi, I need user function for WHERE clause. But I don't know what type of parameters to use for such function: SELECT * FROM Table WHERE MYFUNC(ColumnName, IntValue). Above all - how to returm value to WHERE and what type? Is there any example (tutorial or explanation) in C or C++ for similar problem? Thanks Stan -- View this message in context: http://www.nabble.com/WHERE-with-user-function-tf2015394.html#a5539399 Sent from the SQLite forum at Nabble.com.