Re: [sqlite] WHERE with user function

2006-07-28 Thread Dennis Cote
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

Re: [sqlite] WHERE with user function

2006-07-28 Thread Christian Smith
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

[sqlite] WHERE with user function

2006-07-28 Thread Stan
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