O.K. This is what I need. Thanks
--
View this message in context:
http://www.nabble.com/User-function-in-WHERE-clause-tf2009603.html#a5543377
Sent from the SQLite forum at Nabble.com.
On 7/28/06, Stan <[EMAIL PROTECTED]> wrote:
But there are my problems:
1) Return value xFunc is void? I have to return integer.
2) Where are described parameters in xFunc? E.g. what is it
"sqlite3_context"?
Stan,
Check out section 2.3 User defined funcion s on this page
Thanks for answer. Yes, I have read this many times, but...
...I'm dumb maybe.
I understand first 5 parameters in the "sqlite3_create_function".
xStep and xFinal will be NULL.
But there are my problems:
1) Return value xFunc is void? I have to return integer.
2) Where are described parameters
Thanks for tip. I'm happy to see it's possible.
Alas, I'm rather confused. I have read documentation,
but I'm not sure what parameters to use and what return
value for WHERE clause. Can you be so kind and show
me a skeleton (C++) function for this:
SELECT * FROM Table WHERE MYFUNC(ColumnName,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 8:33 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] User function in WHERE clause
>
> "param MYFUNCTION Name" is equivalent to
&g
"Robert Simpson" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, July 27, 2006 7:48 AM
> > To: SQLite
> > Subject: [sqlite] Re: User function in WHERE
On 7/27/06, Stan <[EMAIL PROTECTED]> wrote:
Hi,
is there a way to create user function similar to LIKE?
I'd like to use my function in clause WHERE. E.g. this selection:
SELECT * FROM Table WHERE Name MYFUNCTION param
Param is integer.
http://sqlite.org/capi3ref.html#sqlite3_create_function
Hi,
is there a way to create user function similar to LIKE?
I'd like to use my function in clause WHERE. E.g. this selection:
SELECT * FROM Table WHERE Name MYFUNCTION param
Param is integer.
Thanks
Stan
--
View this message in context:
8 matches
Mail list logo